Connection to SQL-server through ODBC connection

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
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

read ODBC Connection 7
Snowflake to SSIS 0
BackEnd database through ODBC-connection 7
ODBC to SQL-server - how do I log in via code 2
ODBC Connection 1
Why linked sql database is read only 2
Error handler not catching SQL Server Connection failure 2
How to create DSN-Less Connection to AS400 1

Top