How to avoid sql login dialog box to run access query

  • Thread starter Thread starter Jack
  • Start date Start date
J

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top