Connection to SQL-server through ODBC connection

  • Thread starter Thread starter ReidarT
  • Start date Start date
R

ReidarT

I use an ODBC-coonection to link some tables to an Access database.
This is a frontend, backend database.
The strange thing is that on some machines this works ok, but on some
machines
when you try to access tables in the SQL-database, you have to enter
username and password.
The connection string is located on thr server where all users have the same
rights.

regards
reidarT
 
Mybe,
If the ODBC set to Authentication, then Access will log automatically to the
Server, but in this few computers it might be set to Login

Check the ODBC connection in the computer (using the adminstrative tools)
 
Back
Top