Relinking Tables Require Pass - How To Connect Multiple Users to Online SQL Server Databases Using Microsoft Access and Web ASP


	Back to Access SQL Server Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Relinking Tables Require Pass

Jeremy Hansen

4 years ago

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 Hansen OP @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.

	Richard Rost @Reply 4 years ago
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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access SQL Server Lessons.

Next Unseen

New Feature: Comment Live View