D
dave
Hi all,
This is my first post,
We have an access 2003 frontend that links to a sql 2000 backend server and
the tables are linked and an odbc connection is set up on each user machine
for the link to work.
Is there anyway of writing a script in access2003 to make this connection
automatic so we don't need to visit ever users machine and create a local
dsn odbc connection.
Any help would be grateful
Regards.
David
This is my first post,
We have an access 2003 frontend that links to a sql 2000 backend server and
the tables are linked and an odbc connection is set up on each user machine
for the link to work.
Is there anyway of writing a script in access2003 to make this connection
automatic so we don't need to visit ever users machine and create a local
dsn odbc connection.
Any help would be grateful
Regards.
David