linked table

[pier117]

Where does ms access store passwords for linked tables? I have a table that occasionally loses it's password.

[nico5038]

Open the linked table in design mode. The select View/Properties and in the description the link will be visible with the UID and Password.

You can relink such a table using code like:

Dim td As DAO.TableDef

For Each td In CurrentDb.TableDefs
  If td.name = "<YouLinkedTableName>" Then
     td.Connect = "<YourNeededLinkWithUserID/Password>"
     td.RefreshLink
  End If
Next

Just relace the <..> fields as needed.

Nic;o)

[pier117]

There is no password in there.... Is there another place to look?

[nico5038]

Not that I'm aware.
Perhaps there's no UID/PW required for your excel workbook.

When there is, you could try to add hem to the link.

Nic;o)