Access/SQL Server Connection

[Guest_imported]

Hello,

I have recently ported an Access application to SQL Server 7.0. I am using Linked ODBC tables through Access. I have a little problem that I need help resolving. Whenever the first user of the day attempts to login the are also presented with a screen that is showing the DSN name, username for the SQL Server account and asking for a password. I set this up correctly in the ODBC driver, so why is it asking me again? How can I get around this?

Thanks in advance!
David

 

[DougP]

Try this
Add a new SQL table and when it shows the Box to pick a Index field (key field) look on the box for a Password check box, check it and then continue. close Access and then open that database again and click on that table. It should not ask for anything.
If that fixes this one then you have to delete every linked table and re-do them all checking the box each time.
If that’s not the fix then you have to look at your permissions in SQL .
Are they using NT authentication (using the NT domain login to obtain permissions or a SQL login (users set up in SQL).
This is done when you set up the DSN on the machine.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive