Linked Tables via ODBC, How do I connect automatically.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean - 15 Sep 2005 20:02 GMT

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

Reply to this Message

Alex Dybenko - 15 Sep 2005 21:15 GMT

Hi,
perhaps this can help you:
http://www.mvps.org/access/tables/tbl0010.htm

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> My Access database is linked to many tables in our MAS90 database system.
> I
[quoted text clipped - 5 lines]
>
> Sean

Reply to this Message

Sean - 15 Sep 2005 23:25 GMT

I need something a little simpler; I am new at this. Any ideas?

> Hi,
> perhaps this can help you:
[quoted text clipped - 9 lines]
> >
> > Sean

Reply to this Message

oozyscab - 16 Sep 2005 21:28 GMT

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.

Reply to this Message