Linked Tables via ODBC, How do I connect automatically.

S

Sean

My Access database is linked to many tables in our MAS90 database system. I
have many Make Table queries that are executed by a command button on my main
form. When I click the command button, I am prompted by MAS90 for my odbc
login. I need a line of code that will automatically send my odbc login
information so I do not have to type it in. Can anyone assist?

Sean
 
O

oozyscab via AccessMonster.com

Have you tried saving the password with the connection string when you link
the tables? When you link via ODBC you are given the option to save the
password. By selecting this option you are never prompted to log in.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Security in Access 2013 1
How to have two tables on same line? 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
linking tables via ODBC 2
ODBC Connection String mystery 2
Access 2007 link table login 0
query to linked table timing out 4
ODBC Connection & auto-login 0

Top