DSN-less connections

[Rosemary]

Hello,

I have two pass-through queries in my database. Each one draws from another
database on our network to populate two fields with drop-down lists. The two
fields are on our Main form (which we use to log in jobs).

I had set the pass-through queries up with ODBC DSN connections, which I
physically placed on each user's pc in our department.

Now we are extending use of the database to others in the company, and we
have determined that DSN-less connections will be more efficient because we
will no longer have to set up each user's pc individually.

I have never done a DSN-less connection. I have pulled some sample
connection strings from the Internet. However, I do not know where or how to
place these connection strings. Do I create a module?

The connection needs to take place as soon as the database is opened. The
database opens with a login procedure followed by the Switchboard.

Many thanks,

 

[Dirk Goldgar]

Hello,

I have two pass-through queries in my database. Each one draws from
another database on our network to populate two fields with drop-down
lists. The two fields are on our Main form (which we use to log in
jobs).

I had set the pass-through queries up with ODBC DSN connections,
which I physically placed on each user's pc in our department.

Now we are extending use of the database to others in the company,
and we have determined that DSN-less connections will be more
efficient because we will no longer have to set up each user's pc
individually.

I have never done a DSN-less connection. I have pulled some sample
connection strings from the Internet. However, I do not know where
or how to place these connection strings. Do I create a module?

The connection needs to take place as soon as the database is opened.
The database opens with a login procedure followed by the Switchboard.

Many thanks,

Have you seen Doug Steele's article on the subject:

http://www.accessmvp.com/djsteele/DSNLessLinks.html

?