Password

[VBonliner]

Hi,

I am trying to open a database, but I always get
Error: Not a valid password even though the password
is correct.

Set dbsCustomers = OpenDatabase(“c:\Customers.mdb”, False, False, ";pwd=thepassword123")

Any suggestions. Thanks.

[Jamagei]

try this line

Set dbsCustomers = Workspaces(0).OpenDatabase("C:\Customers.mdb, False, False, "MS Access;pwd=thepassword123")

it works for me.

[VBonliner]

Hi Jamagei

The problem was that Access doesn't like passwords that
start with a number (My actual password started with a
nuber)!

Thanks for your help