Linking tables from password protected Backend db

[anb001]

In my Frontend db, I use 'J Street Access Relinker' (http://www.jstreettech.com/cartgenie...rDownloads.asp), as suggested in another post, to link to my Backend db.

If I protect my Backend db with a password, from the Security menu in Access, it is no longer possible to link to the Backend db, or at least the Frontend can't open the links.

It there a way for me to set the password via code in my frontend db, so the linking can be done?

Thanks.

/Anders

 

[larek]

Same problem. Any solutions?

 

[anb001]

Else where on the internet, I have found that when using 'J Street Access Relinker' (see link to code in top post), you can insert a password in following line, where the password part is in bold:

tdf.Connect = ";DATABASE = " & PathOnly(CurDB.Name) & FileOnly(strFileSearch) [B]& ";PWD=test[/B]"

However, I get an error message, stating that this is a wrong password when relinking.

Can anyone inform if this indeed is the correct place to put the 'PWD'? And how it should look like, as above is probably wrong.

Thanks.