Changing password for a linked table to an online database

[Kyle]

One of our former coworkers developed an Access report that pulls information
from our online database for its table. The problem is this online database
is protected by unique UID's and passwords. He programmed in his username and
password, which gained him access to the online database for the tables.

The problem is he left the company, and now his username and password are no
longer accepted. How do I go about switching his login information over to my
own?


Thank you for your help!

 

[Albert D. Kallal]

One of our former coworkers developed an Access report that pulls
information
from our online database for its table. The problem is this online
database
is protected by unique UID's and passwords. He programmed in his username
and
password, which gained him access to the online database for the tables.

The problem is he left the company, and now his username and password are
no
longer accepted. How do I go about switching his login information over to
my
own?

Just re-link that table in question. There is likely only one linked table.
It not clear if he used a DSN, or has some code in the application that sets
up the linked table....

Regardless....just highlight that one table and right click on it....I
believe you can choose linked table manager at that point...

 

[Kyle]

He used a DSN, and I'm figuring it will be much quicker and less painful if
there was a way to just update the login information, rather than relinking
the whole thing again.

 

[Albert D. Kallal]

He used a DSN, and I'm figuring it will be much quicker and less painful
if
there was a way to just update the login information, rather than
relinking
the whole thing again.

Right, but only talking about a table here? Unless there are "many" tables?
In that case, then consider using some code to re-link for you.

there is a DSN-less sample here:

Using DSN-Less Connections
http://www.accessmvp.com/djsteele/DSNLessLinks.html