Changing password for a linked table to an online database

  • Thread starter Thread starter Kyle
  • Start date Start date
K

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!
 
Kyle said:
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?
Click to expand...

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...
 
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.
 
Kyle said:
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.
Click to expand...

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
 
Back
Top