Automate Relinking Tables for Password Protected database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisab - 06 Nov 2007 20:59 GMT

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

Reply to this Message

Alex Dybenko - 07 Nov 2007 09:23 GMT

Hi,
connect string should be like this:

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

Signature

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

>I am using the code found in Access Web to automate Relinking Tables
> http://www.mvps.org/access/tables/tbl0009.htm
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message

Lisab - 14 Nov 2007 21:03 GMT

thanks.

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

> Hi,
> connect string should be like this:
[quoted text clipped - 14 lines]
> >
> > Thanks

Reply to this Message