S
Scoop
I am working with an Access database that has a number of link tables
to a remote SQL server (actually MSDE) database. When the Access
database was setup, a file DSN was created to connect to SQL Server.
I now have a number of users trying to open the Access database from a
network share and some of them are recieving an "ODBC Connection
Failed" message. My initial thought was that it has to do with them
not having the DSN setup on their respective workstations but I have
other users who can open the Access database and see data from the link
tables just fine and they also don't have a local DSN setup.
The only patern I can see is that those that can connect to the link
tables have elevated rights on the DB server. I can understand if it's
rights issue but I don't understand how the connection is being made in
the first place. There is no code/connections strings, etc. so how
does Access maintain the connection information?
In some previous posts, I noticed that some people had trouble in
similar situations with MDAC versions but I think I have ruled that
out.
Can anyone offer any ideas as to what's going on here? or explain to me
the best way to ensure that all users can open this Access database and
not have any trouble with the link tables?
Thanks!
to a remote SQL server (actually MSDE) database. When the Access
database was setup, a file DSN was created to connect to SQL Server.
I now have a number of users trying to open the Access database from a
network share and some of them are recieving an "ODBC Connection
Failed" message. My initial thought was that it has to do with them
not having the DSN setup on their respective workstations but I have
other users who can open the Access database and see data from the link
tables just fine and they also don't have a local DSN setup.
The only patern I can see is that those that can connect to the link
tables have elevated rights on the DB server. I can understand if it's
rights issue but I don't understand how the connection is being made in
the first place. There is no code/connections strings, etc. so how
does Access maintain the connection information?
In some previous posts, I noticed that some people had trouble in
similar situations with MDAC versions but I think I have ruled that
out.
Can anyone offer any ideas as to what's going on here? or explain to me
the best way to ensure that all users can open this Access database and
not have any trouble with the link tables?
Thanks!