Pass-Through Queries and File DSNs

[Guest]

Hello,

I have a small Microsoft Access 2002 database application that tracks the
work in our department. There are a maximum of 7 users accessing it at a
time.

I have created two pass-through queries for our Main data entry form. Each
query pulls data from a different database on our system. I set up system
DSNs on our department PC's. However, for future maintenance reasons, our IT
department has requested I set up file DSNs instead, especially since other
users outside our department will eventually use the database.

I need some assistance setting up a file DSN, please. I have done research
on the Internet on file DSNs, and know the general methods for creating them.
However, I need some assistance with the details and specifics.

I understand the steps are to create a text file with the parameters in it,
and to name the file using a ".dsn" extension.

1) What parameters do I need to include? Here are the connection strings
for the system DSNs:

ODBC;DSN=Query1;UID=useridone;PWD=nifty;DATABASE=dbGSK01

ODBC;DSN=Query2;UID=useridone;PWD=nifty;DATABASE=dbPSM01

For Microsoft Access 2002, do I also need to include such properties as
UserCommitSync, Threads, SafeTransactions, PageTimeOut, MaxScanRows, etc.?

2) How do I write the connection string to the file DSN?

3) Where do I place the file DSN connection string -- in the ODBC
Connection String property of the Querys' properties?

4) Where do I store the file DSN? Right now, my database is stored on a
local network drive (both front end and back end in the same folder).
Eventually, I will move the front end and place a copy on each pc in the
department.

Many thanks,

 

[Dave Patrick]

It will be much easier to just use the 'File DSN' tab of the built-in ODBC
configuration tool.
Start|Run|odbcad32.exe

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hello,
|
| I have a small Microsoft Access 2002 database application that tracks the
| work in our department. There are a maximum of 7 users accessing it at a
| time.
|
| I have created two pass-through queries for our Main data entry form.
Each
| query pulls data from a different database on our system. I set up system
| DSNs on our department PC's. However, for future maintenance reasons, our
IT
| department has requested I set up file DSNs instead, especially since
other
| users outside our department will eventually use the database.
|
| I need some assistance setting up a file DSN, please. I have done
research
| on the Internet on file DSNs, and know the general methods for creating
them.
| However, I need some assistance with the details and specifics.
|
| I understand the steps are to create a text file with the parameters in
it,
| and to name the file using a ".dsn" extension.
|
| 1) What parameters do I need to include? Here are the connection strings
| for the system DSNs:
|
| ODBC;DSN=Query1;UID=useridone;PWD=nifty;DATABASE=dbGSK01
|
| ODBC;DSN=Query2;UID=useridone;PWD=nifty;DATABASE=dbPSM01
|
| For Microsoft Access 2002, do I also need to include such properties as
| UserCommitSync, Threads, SafeTransactions, PageTimeOut, MaxScanRows, etc.?
|
| 2) How do I write the connection string to the file DSN?
|
| 3) Where do I place the file DSN connection string -- in the ODBC
| Connection String property of the Querys' properties?
|
| 4) Where do I store the file DSN? Right now, my database is stored on a
| local network drive (both front end and back end in the same folder).
| Eventually, I will move the front end and place a copy on each pc in the
| department.
|
| Many thanks,
|