Turn on the macro recorder and do it manually. Then turn it off and look at
the code.

--
Regards,
Tom Ogilvy

"Todd Huttenstine" wrote in message
...
Hey guys

Using ODBC, it is possible to set up a connection to a
database. Instead of having to do this manually for
multiple computers, I would like to be able to run a code
that will do it automatically. For instance if I wanted
to setup a database connection to file C:\test.mdb, I
would open up the ODBC managaer and then type in a
description, navigate to the source, etc.. How do I write
code that will set up a system database connection to a
file called test.mdb located on C:\?


Thanks
Todd Huttenstine