Hide SQL Server Login Screen

J

jk

I have a Microsoft Access 2000 database that I converted the back-end
to SQL server 2005 and kept the front-end same. Is there any way I can
hide the pop up screen for SQL Server connection so that the users
don't have to enter userid and password when they try to run a
query/report?
Can I create a macro or may be some VB script to do this?
Thank you and appreciate your help.
 
J

John Spencer

Well, you could use a trusted connection if you've set up the SQL database
correctly. OR try "googling" these groups for DSNless connections and Duane
Hookom. That may point you to some solutions.
 

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

Similar Threads

MS Access Query criteria Problem 2
unable to run the query 2
SQL Server Login requesting password when query is run. 4
SQL server backend 2
Using of sql server for back end database 3
Linking to SQL Server tables using Access 97 in Windows XP 1
Action Query (Append) didn't add records due to key violations. 5
Query not working for SQL Server 2

Top