SQL login to Access

[baa]

We have a custom application written for Access 2000 on the front-end and has SQL 7 on the back-end.

Since the last time the developer made changes, the SQL login box no longer saves the User ID from the last login. It saves the user name that I used when I attached and compacted the database, and it never changes, even after another user logs on.

I did a little research and it seems that the application should be pulling this value from the key "LastUser" in the registry. This value is located in the registry at: HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\HMSSQL.

However, I am unable to find where the Access front end looks for this key.

Does anyone have any ideas or advice?

Thanks--

Beth

 

[tlbroadbent]

I can think of two possibilities. [ol][li]When you link a table, Access asks if you want to save the password. If you answer "Yes", then Access will not ask for the password again. You'll need to relink the table.

[li]There is known bug in a recent version of SQL Server ODBC driver. "The authentication settings for ODBC data source names (DSNs) are ignored. The driver attempts to log directly into SQL Server using NTLM authentication (integrated security) without prompting for a user ID and password." See the followin article for more info.

FIX: SQL Server ODBC Driver Ignores Authentication Setting

http://support.microsoft.com/support/kb/articles/Q279/5/26.ASP

[/ol] Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin