I have an application created in Access 2003 that uses the ODBC system DSN to connect to SQL Server. ODBC uses SQL authentication. When the application starts, the user is prompted to authenticate to the database.
I have another computer configured in the same domain on which Access 2007 is installed. I log in using the same credentials that I use to access the machine with Access 2003.
I converted my application to Access 2007 format and everything works fine. However, when other users try to use the application, they are prompted to enter the database password each time they access the table. Thinking this was a problem with my ODBC, I confirmed that the connections were configured the same on both my machines and the user's machine.
Here is the interesting part, when a user entered my car, he each time started asking for a password. When I logged in the user, the application worked fine.
Does anyone have any ideas? All help is appreciated!
source
share