I created a TblUsers in the back end and when I new open the linked table manager in the front end, it does not show that table. It is not hidden. What happened, what do I do?
Office 365Pro plus.
I created a TblUsers in the back end and when I new open the linked table manager in the front end, it does not show that table. It is not hidden. What happened, what do I do?
Office 365Pro plus.
Link it in again.
You have to create a link to the new table. It does not happen automatically.
Assuming the BE is an Access file, you don't use the Linked Table Manager, you click on External Data, then on ACCESS (in A2010 - don't have O365) - follow the wizard steps to LINK to a table..
If you have a linked table and you MODIFY the table in the BE, then you would use the Linked Table Manager to refresh the linked table to show the changes to the BE table.
You mean modify the design? How do you modify the design in a linked BE table from the front end (notwithstanding code that you might run from the fe on a be database table, but why would you when you could just open the be and make mods from there)? Or did you mean something else?If you have a linked table and you MODIFY the table in the BE
There is one other reason I've seen as the problem but not sure where I saw it posted. The user was opening the wrong back end to find the table.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Ok,Ok.... (yes, it wasn't especially clear/precise)
If you open the BE in design view and add/delete/rename one or more fields, then you would use the Linked Table Manager in the FE to refresh the linked table to show the changes to the BE table.
Howz this??
Not bad - except if you modify a be table in that db and open that table in the fe, the new field is there anyway - even if the fe was already open. If the table was open in the fe (or I suppose had a lock on it) you can't modify that table in the be.
At any rate, you don't have to relink to see the new field.
I know you're going to try it when I'm not looking...
When I go to the linked table manager, it shows me all tables that a linked to he front end. It has been a long time since I programmed, but I seem to remember that there were tables that were not linked and therefore not checked.
The BE has the new table I just added.
I switch to the FE. The linked table manager shows me all tables which are already to the front end, but not the newly added table.
Using your suggestion on line 2, that can only export the file to another file, not link.
That is the step I was missing. Thanks for the pictures, was looking at the wrong thing. I got it. Solved