Database Connectivity

[Larry Bates]

Aaron Bingham wrote:
> Sandeep Avinash Gohad wrote:
> 
>>  
>> Hi
>>
>> I want to develope a simple Database connectivity program with python.
>> I want to use MS Access as a backend.
>> Please guide me....
>> If any e-books,links available particularly for database connectivity
>> then please let me know
>>
>> Regards
>> Sandeep
>>  
>>
> First, consider if you really want to use MS Access for this.  In my 
> experience, this is mostly asking for trouble as Access is poorly 
> documented and has many bugs and misfeatures you will waste your time 
> working around.  In addition, Access DBs are prone to corruption if 
> accessed by many users at once.  PostgreSQL is a much more powerful 
> alternative, and version 8.0, coming soon, will run natively on 
> Windows.  Of course, it is not as "user friendly" in the sense of having 
> pretty GUI tools, but since it sounds like you will be writing the GUI 
> in Python anyway, this may not matter.
> 
> If you are going to use Access, Python Programming on Win32 by Mark 
> Hammond and Andy Robinson is an essential reference.
> 
> Aaron
> 
I wrote and contributed a DAO interface class that I've used to
read/write data from/to Access databases located here:

http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/303349

Larry Bates