ODBC Linked Tables

[AnV]

In order to use Access 97 as your frontend and SQL 7 as your backend on a
network (where the frontend is located on the same computer as the backend and
people just map to Access frontend) where security for the data is recognized
by your domain login account and what domain group you belong to..do you
have to have the same System DSN on everyone's computer for linking? I am
still having problems with people linking to the SQL server through the network and only my account is working correctly from my desktop. Everyone
else who tries to link gets an ODBC failure error message when trying to
open one of the linked tables. I have heard from one person that you must
have the same system DSN on every client's computer but to me that makes no
sense as I do not have the DSN listed on my individual computer...I am just
going through the network as myself..not as an admin..and getting directly
to the data. Everyone else can get to the shared folder on the server but
cannot get to the linked tables. Any ideas?

[Paul]

yes same system DSN on each machine. Make sure everyone has permissions for the tables.

try running latest MDAC sofware.

------------
AnV at 3/23/01 10:41:33 AM


In order to use Access 97 as your frontend and SQL 7 as your backend on a
network (where the frontend is located on the same computer as the backend and
people just map to Access frontend) where security for the data is recognized
by your domain login account and what domain group you belong to..do you
have to have the same System DSN on everyone's computer for linking? I am
still having problems with people linking to the SQL server through the network and only my account is working correctly from my desktop. Everyone
else who tries to link gets an ODBC failure error message when trying to
open one of the linked tables. I have heard from one person that you must
have the same system DSN on every client's computer but to me that makes no
sense as I do not have the DSN listed on my individual computer...I am just
going through the network as myself..not as an admin..and getting directly
to the data. Everyone else can get to the shared folder on the server but
cannot get to the linked tables. Any ideas?

[David Westmore]

I have many different applications with this architecture, I try not to use DSNs at all.

What I normmaly do is to link the tables to the MDB file using a FILE DSN. I don't know why, but the effect of this is that the attached tables "remember" the whole connection string to the database. This is useful, I don't want to run around installing DSNs on users' PCs.

I always use NT integrated security and it works just fine. You MUST install at least MDAC 2.1 to use integrated security, it might be a good idea to use MDAC 2.5.

Go to www.microsoft.com/data/ to download the various versions of MDAC. Avoid the MDAC 2.6 if you use DTS a lot.

Hope this is useful

David Westmore


------------
Paul at 3/23/01 12:22:24 PM


yes same system DSN on each machine. Make sure everyone has permissions for the tables.

try running latest MDAC sofware.

------------
AnV at 3/23/01 10:41:33 AM


In order to use Access 97 as your frontend and SQL 7 as your backend on a
network (where the frontend is located on the same computer as the backend and
people just map to Access frontend) where security for the data is recognized
by your domain login account and what domain group you belong to..do you
have to have the same System DSN on everyone's computer for linking? I am
still having problems with people linking to the SQL server through the network and only my account is working correctly from my desktop. Everyone
else who tries to link gets an ODBC failure error message when trying to
open one of the linked tables. I have heard from one person that you must
have the same system DSN on every client's computer but to me that makes no
sense as I do not have the DSN listed on my individual computer...I am just
going through the network as myself..not as an admin..and getting directly
to the data. Everyone else can get to the shared folder on the server but
cannot get to the linked tables. Any ideas?