Tables cannot be seen in rear end

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 21:47

I have quite a few linked tables in my front end, most from the same back end. Yet there are some I can't see in the back end.
The tables aren't hidden. They show as being in the backend, yet are invisible.
How do get them revealed?

Post by **HansV** » 26 Jan 2022, 21:50

What does Backend.pdf show?
What happens if you try to refresh all links in the Linked Table Manager?

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 21:54

Can't see an option to do that. (Access 2010)

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 22:00

Sorry, missed "What does Backend.pdf show?"
'Linked table Manager' is greyed out on the back end. All I can see is the 'navigation options' which I attached.

Post by **HansV** » 26 Jan 2022, 22:14

Try refreshing all linked tables in the front-end database. Does it succeed or do you get an error message?

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 23:20

Can't see where to refresh linked tables links

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 23:31

I worked out how to refresh all tables. Not the most intuitive.
No luck, the tables are still not showing in the back end. The link addresses are correct in the linked table manager.

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 23:35

Did a compact & repair on both front & back ends, then did another refresh all. No luck.

Post by **HansV** » 26 Jan 2022, 23:41

In the back-end, click the drop-down arrow in the title bar of the navigation pane on the left.
Select 'Object Type' and 'All Access Objects'.
Next, right-click the title bar of the navigation pane.
Select 'Navigation Options' from the context menu.
Tick both the 'Show Hidden Objects' and 'Show System Objects' check boxes, then click OK.
Do you see the table now?
(It is a good idea to clear the 'Show System Objects' check box again afterwards)

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 23:43

Do you think that, in the absence of an easier method, that making the tables local in the front end, then importing them into the back end and then linking to the front end would work?
I am concerned that, as the tables are definitely in the back end, doing the above would result in corrupt tables - or Access wouldn't let me do it as it would be duplicating. Just thinking out loud (well in text).

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 23:45

I did that show hidden and system stuff awhile ago. The hidden box was unticked. Ticking the system box did nothing.

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 23:46

Hey Hans, although incredibly appreciated, don't stay up just on my account.

Post by **HansV** » 26 Jan 2022, 23:52

Peter Kinross wrote: ↑
26 Jan 2022, 23:43
Do you think that, in the absence of an easier method, that making the tables local in the front end, then importing them into the back end and then linking to the front end would work?
I am concerned that, as the tables are definitely in the back end, doing the above would result in corrupt tables - or Access wouldn't let me do it as it would be duplicating. Just thinking out loud (well in text).

You could try this on a copy of both databases.

Peter Kinross · Post by **Peter Kinross** » 26 Jan 2022, 23:57

Sounds like a plan.
Will let you know - probably tomorrow. I'm feeling guilty, Go to bed

Post by **HansV** » 27 Jan 2022, 00:04

Going to bed now

Peter Kinross · Post by **Peter Kinross** » 27 Jan 2022, 06:42

It worked! danged if I can see how the tables were working without being visible in the back end.

ThanksHansStamp.gif

Eileen's Lounge

Tables cannot be seen in rear end

Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end

Re: Tables cannot be seen in rear end