access to MS Access password-protected database?

Tim Golden mail at timgolden.me.uk
Wed Feb 11 11:17:40 EST 2009


Ken McDonald wrote:
> Can anyone direct me towards a code snippet showing how to use Python to 
> insert data into a password-protected MS Access database? My google 
> searches have been uninformative for dbs that are password-protected.

Caveat: I've never done it and I have no Access db to hand,
but in a spirit of being helpful...

According to this snippet:

http://www.vb-helper.com/howto_ado_use_access_password.html

it can be done via ADO. You can either roll your own, or you
can use the adodbapi module from the pywin32 extensions.

TJG



More information about the Python-list mailing list