Question How to get Access to cache password for ODBC

[MarMan]

Hello

We have an Access 2003 database that displays reports to the user from tgables linked to SQL server. It works perfect on my machine (I am a windows admin) but prompts the user for a password on thier machine. I am not concerned about security since the user to get the data for the reports has read only access. I went over this article blogs.office.com/2011/04/08/power-tip-improve-the-security-of-database-connections/ but it did not help. I deleted all linked tables and created a new DSN with the read only user. Then I re-linked the tables but it did not help. But now it is consistently broken, both on my machine and the users machine.

How can I get it to stop asking for a password? I was under the impression that it caches the connection string which is what I would like. I'll hard code it if I must but that does not sound like the best way.

JM

 

[Ranman256]

in the ODBC app, remove the existing setup for your db. Then add it again, but be sure to checkmark the box REMEMBER PASSWORD.

 

[MarMan]

Thanks for your reply.

There is no setup. There is only an Access mdb and a DSN which I only have because the linked table manager requires one.

 

[WayneRyan]

Madman,

Ranman is right.

When you link the table there's a very inconspicuous opportunity to check the
"Remember password".

Delete the link and try again.

Wayne

 

[MarMan]

WaiterRamen,

Thanks I found it. But just so you guys know, in the software industry when someone mentions "setup" it generally refers to ancillary software that performs functions such as copying files, writing to the registry, ect. Perhaps he was trying to make it easy for me but for future reference, if you wish to be clear, you can mention tasks by the identifiers used in the menus. I may have found the solution sooner if "Database Utilities" or "Linked Table Manager" was used instead of setup.

Thanks
Marman