Tables cannot be seen in rear end
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Tables cannot be seen in rear end
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?
The tables aren't hidden. They show as being in the backend, yet are invisible.
How do get them revealed?
You do not have the required permissions to view the files attached to this post.
Avagr8day, regards, Peter
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Tables cannot be seen in rear end
What does Backend.pdf show?
What happens if you try to refresh all links in the Linked Table Manager?
What happens if you try to refresh all links in the Linked Table Manager?
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
Can't see an option to do that. (Access 2010)
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
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.
'Linked table Manager' is greyed out on the back end. All I can see is the 'navigation options' which I attached.
Avagr8day, regards, Peter
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Tables cannot be seen in rear end
Try refreshing all linked tables in the front-end database. Does it succeed or do you get an error message?
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
Can't see where to refresh linked tables links
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
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.
No luck, the tables are still not showing in the back end. The link addresses are correct in the linked table manager.
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
Did a compact & repair on both front & back ends, then did another refresh all. No luck.
Avagr8day, regards, Peter
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Tables cannot be seen in rear end
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)
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)
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
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).
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).
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
I did that show hidden and system stuff awhile ago. The hidden box was unticked. Ticking the system box did nothing.
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
Hey Hans, although incredibly appreciated, don't stay up just on my account.
Avagr8day, regards, Peter
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Tables cannot be seen in rear end
You could try this on a copy of both databases.Peter Kinross wrote: ↑26 Jan 2022, 23:43Do 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).
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
Sounds like a plan.
Will let you know - probably tomorrow. I'm feeling guilty, Go to bed
Will let you know - probably tomorrow. I'm feeling guilty, Go to bed
Avagr8day, regards, Peter
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Tables cannot be seen in rear end
It worked! danged if I can see how the tables were working without being visible in the back end.
You do not have the required permissions to view the files attached to this post.
Avagr8day, regards, Peter