Linked tables don't appear to be (3 Viewers)

[ryetee]

I'm working on a small database that has linked tables to effectively 2 back ends
I went into the link table manager to not only check what's linked to what but to relink everything as well
Lo and behold the list of linked tables is empty
I can display the contents of each table so they are linked but I can't relink
I will need to do this eventually as the test and production locations are different
Any suggestions?

 

[Gasman]

They definitely have an arrow on them?

See this thread.

 

[MajP]

They definitely have an arrow on them?

I am thinking the same thing, that you might have mistakenly imported the tables not linked them.

 

[ryetee]

I'm using access 2016 btw

 

[ryetee]

They definitely have an arrow on them?

See this thread.

Yes they do and if I hover my mouse over them I can see the link. If I open the link manager it shows me nothing.
If I select all (from nothing) and click the re link box it throws up a window so I can get the location of the linked table (if I knew it).
This was working a few days ago as I put a new table in the back end and relinked it in the conventional way

 

[ryetee]

I am thinking the same thing, that you might have mistakenly imported the tables not linked them.

no they were originally linked (and still are), I just can't see them to relink

 

[MajP]

I guess try and relink them as if they do not exist. Chatty says the same

• Re-link tables if they exist but don't show up:
  • From the External Data tab, click Access.
  • Choose the Link Table radio button.
  • Browse to the database containing the tables you wish to link and select them.

 

[isladogs]

Perhaps the tables were hidden in the original datase and so are hidden now as linked tables.
Try making hidden objects visible in the nav pane.