Refresh Links to Passworded Back End

N

N. Cotton

I currently connect the front end to the back as follows:

db.TableDefs(i).Connect = ";DATABASE=" & strBackEnd
db.TableDefs(i).refreshlink

I would like to password the back end which is fine if i then manually
re-link the tables to the front end proving the db password.

If I then relink using the code above I get an invalid password error.

The connect string still holds the password...
MS Access;PWD=passwordtest(3;DATABASE= ect
its obviously just the back end location that changes.

Is there any way to get the refreshlink to work on a passworded back end?

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
add password to circumvent mysql connector pop-up 3
Front End / Back End & Password Protection 6
Relinking Excel table 5
Problem relinking back-end with password 1
Connect to back end over the Internet? 7
password issue on back end database 4
Relink to tables with password on BE 4

Top