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