How to avoid sql login dialog box to run access query Jack 12/30/2008 5:50:03 PM 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.

Re: How to avoid sql login dialog box to run access query "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/31/2008 12:08:13 AM 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 "Jack" <Jack[ at ]discussions.microsoft.com> wrote in message news:B989ADF4-86DC-4807-BB8B-51F6A5F92122[ at ]microsoft.com... [Quoted Text] > 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.