ODBC Data Source names for both Oracle and SQL server are locally installed
on each client PC.

Good luck.

Best thing to do is train users to create their own DSN's or never allow an
MS Access "DB"
to be used by more than one person, it was designed to be a local DB and is
not scaleable.



-----Original Message-----
From: John Duran [mailto:[Email Address Removed] Wednesday, December 17, 2003 8:41 AM
To: LazyDBA.com Discussion
Subject: MS Access and SQL


I have inherited a rather chaotic mix of MSAccess programs, some of which
were tied to some SQL Server tables.



The problem I am encountering is:



Certain individuals are able to connect to the SQL Tables, but if I try to
connect others, the ones with previous connections start receiving ODBC
errors.



Question: What do I need to do to ensure that a single MSAccess program
will allow all Domain users (NT Authenication) to see and use all the SQL
tables within the required databases?



JOhn

MS Sql Server LazyDBA home page