[Tutor] Microsoft Access

Alan Gauld alan.gauld at btinternet.com
Fri Dec 28 11:11:35 CET 2007


"Jim Morcombe" <jmorcombe at westnet.com.au> wrote 

> This tutorial seems very specific to PythonWin IDE.  
> I haven't tried it, but it seems to imply that it uses stuff 
> from PythonWin IDE that may not be available in IDLE.  

The IDE is just an IDE - editor and debugger etc.
But the winall package is how you get access to the 
Windows libraries for COM/ADO etc You can download 
winall on top of standard python. You then have the choice 
of IDLE or Pythonwin as an IDE - I prefer Pythonwin.

However if you don;t want to do that you can access Access 
via ODBC using the standard DBAPI for Python using SQL.
That hasthe advantage that you get familiar with DBAPI 
which also works across Oracle, Informix, DB2 etc etc

But if you want to do any kind of complex stuff with 
Windows then the winall package is pretty essential.
And if you get seruious about programming Windows 
from Python the O'Reilly book by Mark Hammond is 
strongly recommended too - it's old now but still the 
best reference on Windows and Python.

HTH,

-- 
Alan Gauld
Author of the Learn to Program web site
http://www.freenetpages.co.uk/hp/alan.gauld



More information about the Tutor mailing list