Hi all,
I'm wondering if there's a way to remove the password Access (2003)
has stored for an ODBC linked table without quitting and reopening the
application.
I have a set of linked tables which I update with a user's password
on login using tdf.Connect, thereby keeping them from having to use the
linked table manager or see the ODBC connection dialog. When a user
logs out, I set the connect string back to a generic connect string
without a username or password again using tdf.Connect.
When a logout is followed by quitting Access, the changes update
perfectly, and opening a linked tables without logging in opens the
ODBC connect dialog to ask for the password, effectively blocking the
user from getting into the table without entering a password. However,
when the logout is not followed by quitting the application, then the
tables are still holding on to the passwords,
even though
SELECT Name,Connect from MSysObjects shows my updated
(password-less)connection string for these linked tables.
Is there somewhere else that the password is stored that I can clear
out?
The tables are originally linked with DoCmd.TransferDatabase, and I
fooled around with setting the StorePassword parameter to false, but
this resulted in my being unable to get tdf object set when a user
logged in in the first place.
Any advice or suggestions would be greatly appreciated.
Many thanks,
Eric