Microsoft Access Refresh Backend Linked tables Demo

[Mohsin Malik]

Hello,

I have a question that Do someone has build a Microsoft Access "Refresh backend tables" to a password protected backend. I am using Access 2007/2010 and want to build a form where the user input the "Password" for the backend database, browse the database and clicking the refresh button will relink the database tables to that form. Please advise.

Thank you
Mohsin

 

[gemma-the-husky]

you should be able to use any code to relink to a database. the connection string is something like this - not sure of the exact appearance of the password section in this without checking. note that the password (ie the connection string) is plainly visible to anyone who can see the tables within your database, just by hovering over the table name

;database=fullpath; password=whatever