access 2002 linked table to sql asking for password

G

Garabed

How can I avoid being propted for the SQL Server Login everytime a user tries
to run a query from access
 
A

a a r o n _ k e m p f

if you moved to Access Data Projects, then you wouldn't have to worry
about this Jet bug
 

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

Access stripping decimal places in query 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Connect to SQL Server from A2k 4
ODBC Connection not working when database is closed and re-opened. 3
SQL Connection Error with MS Access 7
Username and Password Pop-Up 4
query SQL-server/database via VBA ??? 5
how to check login 2

Top