Microsoft Access Refresh Backend Linked tables Demo (1 Viewer)

Mohsin Malik

Registered User.
Local time
Today, 13:10
Joined
Mar 25, 2012
Messages
175
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

Super Moderator
Staff member
Local time
Today, 09:10
Joined
Sep 12, 2006
Messages
15,614
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
 

Users who are viewing this thread

Top Bottom