I would like to have my DSN connect automatically on startup. Do I have to
jump through all the hoops to use Dev Ashish' code or is there a simple set
of declarations to use. I am only connecting to one DSN and maybe 5 tables
max. I'm more than willing to write explicit code for each table just so my
users don't have to go through the ODBC login procedure.

I am using Access 2K.

Thanks in advance.

Hi,

I'm not sure if this will work for you, however, this is what we did.

Click on the Start button
Click on Control Panel
Click on Adminstrative Tools
Click on Datasources (ODBC)
Click on System DSN tab
Click on Add
Scroll down and click on the desired path/server
Click Finish
Fill out the three text boxes, then click Next
On this next window, choose your radio button and check the box for "Connect
to SQL...)
Click next
complete the next screen as best for your organization.
Click next
check Perform translation for character data
Click Finish
Click Test Data Source

hope this helps, Tracy

"Bill Phillips" wrote:

> I would like to have my DSN connect automatically on startup. Do I have to
> jump through all the hoops to use Dev Ashish' code or is there a simple set
> of declarations to use. I am only connecting to one DSN and maybe 5 tables
> max. I'm more than willing to write explicit code for each table just so my
> users don't have to go through the ODBC login procedure.
>
> I am using Access 2K.
>
> Thanks in advance.