March 16, 2006 at 9:21 am
I have an Access 2000 application that links several SQL Server tables. I want to be able to use 1 username/pwd to connect to those tables. I find that if I specify the username/pwd in the DSN, when I run the app, it still prompts me for a username and password. I want that to go away. Can I somehow create the linked tables to not use ODBC with 1 hard-coded connection? I don't want to use Windows Authentication because I don't want to setup all the users in SQL to have access.
Thanks in advance
Darren
March 16, 2006 at 10:06 am
Have a look at DSN-less connections:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;892490
March 17, 2006 at 5:20 am
In the Link Tables dialog, you can select "Save password" checkbox. This will prevent the request for a password in your app.
Sean
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply