Linked tables don't appear to be (1 Viewer)

[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 database and so are hidden now as linked tables.
Try making hidden objects visible in the nav pane.

 

[MadPiet]

one way to check is to loop the tabledefs collection and do something like print the tablename and the Connect property values. the Connect property has no value, then it's a local table (or so Access thinks).

 

[ryetee]

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

Not unless I've hidden by mistake. It worked a week ago. But I'll double check

 

[ryetee]

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

On the external tab the only access to click is export. There is one under new data source which i've tried already. I tried it on one file and it creates a linked table with a suffix of one. THat doesn't appear when I try the normal method either

 

[ryetee]

one way to check is to loop the tabledefs collection and do something like print the tablename and the Connect property values. the Connect property has no value, then it's a local table (or so Access thinks).

i don't know how to do it. are you suggesting writing code?
the link is there as i can display the contents in the FE and if I hover my mouse over the table in nav pane I can see the link.

 

[isladogs]

Ignore the Export section.
Linked tables are created using the wizard from External Data | From Data Source | From Database then choose the link option

The 1 suffix is automatically created on a newly linked table when the same table has already been linked.

You won't see the original linked tables if you chose to hide them e.g. by clicking Hide in this group using the right click context menu.
To make them visible, check Show Hidden Objects in Navigation Options
The once hidden objects are shown in pale grey

Right click on each and click Unhide in this group to display them normally

 

[ryetee]

Ignore the Export section.
Linked tables are created using the wizard from External Data | From Data Source | From Database then choose the link option

The 1 suffix is automatically created on a newly linked table when the same table has already been linked.

View attachment 121172

You won't see the original linked tables if you chose to hide them e.g. by clicking Hide in this group using the right click context menu.
To make them visible, check Show Hidden Objects in Navigation Options
The once hidden objects are shown in pale grey

View attachment 121171

Right click on each and click Unhide in this group to display them normally

It's not in the navigation pane where I'm not seeing them. It's when I click linked table manager

 

[Gasman]

Try a repair?

 

[isladogs]

It's not in the navigation pane where I'm not seeing them. It's when I click linked table manager

Ah. Sorry I misunderstood

Try running this query & post a screenshot of the results

SELECT
    MSysObjects.Name,
    MSysObjects.Type,
    MSysObjects.Flags
FROM
    MSysObjects
WHERE
    (((MSysObjects.Type) IN (4, 6)));

 

[MajP]

It's not in the navigation pane where I'm not seeing them. It's when I click linked table manager

So maybe I was not clear. Delete the existing ones that you can see in nav pane but not relink utility. Then re-import and you should see in both places..

 

[Ken Sheridan]

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?

You could include your own interface for validating and refreshing the links. The attached zip archive includes two files which illustrate this, one being the front end, the other the back end. The routines in the front end in this case are designed to work with multiple Access back ends.

When the front end is opened, code in its opening form examines the current links. If any are not valid a dialogue form opens in which the validity of each link is given in a list box. One or more items in the list can be selected, and the links refreshed.

 

[Pat Hartman]

one way to check is to loop the tabledefs collection and do something like print the tablename and the Connect property values. the Connect property has no value, then it's a local table (or so Access thinks).

The Connect property is used for RDBMS links. The Database property is used for others.

 

[ryetee]

Try a repair?

done that to both front and back end