Automate Relinking Tables for Password Protected database

[Lisab]

I am using the code found in Access Web to automate Relinking Tables
http://www.mvps.org/access/tables/tbl0009.htm

Problem:
The backend database is password protected
This is just a Database Password - No users or group level security
I get error #3031 - Not a valid password

Question:
Does anyone know how to modify this code so that a password protected
database can be linked using the automated code?

Thanks

 

[Alex Dybenko]

Hi,
connect string should be like this:

MyTable.Connect = ";DATABASE=" & FileName & ";PWD=" & Password & ""


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Lisab]

thanks.

I also had to add it to the Set Database statement
Set dbLink = DBEngine(0).OpenDatabase(strDBPath, False, False,
";PWD=PASSWORD")