By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,688 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

Linked table password storing

P: n/a
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

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.