How to change user name and password in ODBC connection

M

Mehbs

My data is in sql2k server and my users access information or running report
thru Microsoft Access 2003.

Whenever they run the report, it gives them error. So they have to uncheck
the trusted connection and enter sql username and password to get to the
data.

I do I configure and where should I change so user dont have you do this.
It is irritation.

I have one user name and password which is set for readonly in sql. I dont
see any place that I can save this username and password.

I would really appreciate if you kindly help me.

Thanks
 

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

Top