Open with VBA a Password protected db (Win XP Office 2003)

Topic

New Reply

I am trying to open up a dynaset recordset in VBA code using a db different from the one with the code. The external db is password protected. How do I include a parameter in my code to permit opening the external db?

Here is the line of code to open the external recordset:

strLocation = conPWLocation
strTable = “tblPasswords”
Set dbs = OpenDatabase(strLocation)
Set rstPasswords = dbs.OpenRecordset(strTable, dbOpenDynaset)

Thanks.

Reply | Quote

Replies

You can specify the password like this:

Set dbs = OpenDatabase(strLocation, False, False, ";pwd=secret")

Note the semicolon before pwd=. This is required.

See the help for OpenDatabase for more info.

Reply | Quote

Great! We are OK. Thank you.

Reply | Quote