I have inherited a database that used data from an external data source using ODBC linked tables.
The users need to change the password on the external database, but the guy that wrote this db embedded this password in the Access db. I found it specified in record for the link table in the hidden system table "MSsysObject".
I need to change it here, as this particular ODBC driver does not let you specify password there, and if I just replace the link table, it prompts for password, which in this situation will not work.
I do not know how the other guy got the password embedded there, or how to change it.
I've tried going into security and giving myself full administration rights to all the hidden tables, but it makes no difference.
HELP!
The users need to change the password on the external database, but the guy that wrote this db embedded this password in the Access db. I found it specified in record for the link table in the hidden system table "MSsysObject".
I need to change it here, as this particular ODBC driver does not let you specify password there, and if I just replace the link table, it prompts for password, which in this situation will not work.
I do not know how the other guy got the password embedded there, or how to change it.
I've tried going into security and giving myself full administration rights to all the hidden tables, but it makes no difference.
HELP!
