Grzegorz Adam Hankiewicz wrote:
Grzegorz Adam Hankiewicz wrote:
Hello.
I'm following
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/52267 to open a
local .mdb file and export the contents. It works with normal databases,
but I cannot open a password protected database.
According to http://www.oreilly.de/catalog/progacdao/chapter/ there is
no password option in the OpenDatabase method, so I've tried using
daoEngine.DefaultPassword = xxxx without success.
Does somebody know if this is possible and how?
I've found a visual basic example using Dao and the password is passed
as an attribute string. Hence the following will work under python:
daoEngine.OpenDatabase(infile, False, False, "MS Access;pwd=xxxxx")
You want to try visiting:
http://www.connectionstrings.com/
where, for example, you will find:
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database
Password=MyDbPassword;
as a connection string for Access.
-- jv
_______________________________________________
Python-win32 mailing list
Python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
