"Remember Password" using ODBC driver in Access

[Sqwertz]

How do you get Access 2007 to remember the UID/password in a connection
string of a linked table?

I'm using the sotamas90 driver to MAS 200 SQL server database and the
"Remember Password" checkbox doesn't seem to have any effect. Where is
the connection string stored? I've looked at the raw .ACCDB database and
it's not in there according to text searches.

If I could just edit the connection string manually that would probably
solve it. As it is, I can't even read the connection string that was
fabricated when I set up the linked table as it runs off the end of the
screen doing a hover-over with the mouse.

This is no coding in this database. This table is only used VIA the
standard Access GUI's (no forms).

-sw

[Mary Chipman [MSFT]]

I assume you are using SQL logins, so in that case your best bet is to
not use a DSN but to pass the connection information directly to ODBC
when you link the tables. The syntax is available on
connectionstrings.com. Your startup routine can collect the user name
and password from the user and cache it locally in the startup form
property (you can then hide the form). When the user exits, the
startup form deletes the linked tables. This does not delete the SQL
tables, only the links. There is more information in this paper:

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx

--Mary

On Mon, 28 Dec 2009 10:25:48 -0600, Sqwertz <swe...@cluemail.compost>
wrote: