After relinking the tables to the sql server using your code on lesson 05. Relinking TableDefs, ADO (39:06). If you restart the access file it requires you to re-enter your username and password unless you re-link the tables everytime you log in and that takes a long time to start up your application. Is there a way to use vba to relink the tables and save your username and password for the SQL server? Thanks
Jeremy HansenOP
@Reply 4 years ago
I rewatched security 3 and found my answer. Not sure how I missed it. Richard was pretty straight forward on this one.
Yep. And remember, if all of your tables are on the same server, you only need to relink ONE of them. Then the username/password is cached in Access for the remainder of the time it's open. Just relink ONE table when you start your database. I relink my CustomerT each time.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Server Lessons.
