How to avoid sql login dialog box to run access query

[Jack]

Hi,
I have an Access application that has a sql server backend. I had to migrate
the application to a local machine. Now when I am running a access query I am
prompted with sql server login dialog box. This was not the case in the
previous installation. I would like to know how to get this dialog box from
not appearing while running this access query. I would appreciate any help
for resolution of this issue. Thanks.

 

[Jeff Boyce]

Jack

What happens if you try to open one of the tables from the tables tab in the
database window? Does Access ask for the login/password there, too?

If so, when you linked to the backend tables in SQL-Server, you did NOT
check the "remember the password" checkbox. Therefore, if there's a
login/password, you'll need to provide it each time you (your query) 'hits'
that table.

If you are linked to the SQL-Server tables, consider dropping (deleting) the
links, then re-establishing (re-connecting) the links, this time checking
the "save my password" checkbox.

Regards

Jeff Boyce
Microsoft Office/Access MVP