How can I programatically link tables to a password protected back-end in access 2007 without any user prompts asking for the back end password? This is designed for access 2007 runtime environment.
In this project, I am planning on linking all tables to the password-protected back end once the user has entered their login credentials on the login form. The login form briefly connects to the user table on the back end to check the user password then deletes the link through a macro. This is a problem because each time I need to link to the back end, I have to enter the password to the back end.
I would like the password entered programatically each time it tries to connect so it is a seamless process.
I am willing to admit that I may be going at this the wrong way, but if there's a better way to keep the tables un-linked until the user enters their password, that would be great. Thank you for your help and your time.