I am using Access 2000 and in my database I have linked tables from a database on an SQL Server. Everytime I open and close Access and then run a query or try to open the linked table I am asked for my SQL user ID and Password. Is there a way to store this information so that I do not have to continue putting my ID and password ?
yes, Im pretty sure you do it by ticking the "save password" box which appears somewhere during the process when you link the tables via the sql server odbc data source. This assumes you have the user id part of setting up the SQl server odbc data source done correctly.
Try ticking the save password box whenlinking to the sql tables forst and see if that works.