Access and SQL Server, too many logons

[sharonc]

I have an Access database(2000) that is using the switchboard.

Every time I click on an option on the switchboard to open a new form, I get a logon screen to SQL Server(7.0). (my tables are linked to SQL Server)

The recordsource on my forms are hard coded with the table names and field names.

Is there a way to stop all of the login screens from popping up everytime I want to see a new form?

Do I need to use VBA code instead of hard coding the table and field names on my forms?

 

[tlbroadbent]

When linking the tables from SQL Server you have a couple of options.[ol][li]NT Authentication - If you set up the DSN to use NT Authentication and a trusted connection, the user will not need to login as long as his NT login is valid on SQL Server.

[li]SQL Authentication - You can tell Access to save the password in the connection string when you link the tables.

One caveat with MDAC 2.6. There is a bug. The good news is that Microsoft has released a fix in MDAC 2.6 SP1. The article tells about the bug and the fix.

"SQL Server ODBC Driver Ignores Authentication Setting"

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

[/ol]Hope something here helps. Terry Broadbent
Please review faq183-874.

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