Linked Tables via ODBC, How do I connect automatically.

G

Guest

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

linking tables via ODBC 2
ODBC lost connection's 6
Connection to Linked ODBC Tables 2
Connect Oracle Tables via ODBC and VBA 6
ODBC Connection String mystery 2
Creating a table link via ODBC in another ACCESS database 1
Open ODBC connection 4
Re-Linking ODBC Tables 1

Top