Forum Discussion
Linking a frontend to a backend
In older versions of msaccess I could link my tables in the backend to the tables in the fronteend. In Microsoft 365 I will get links to tables with a number attached to it. All my VBA, queries and forms look to the unnumbered tablenames.
Please help me to connect to the original tablenames
arnel_gpThanks for your response, arnel. Your advice worked on my testset. Now I will work on the FE with some 20 linked tables.
- just maybe there is Already an existing linked/local table with same name that is why when you create a New Linked table it Renumber it.
make a copy of your FE.
on the Copy (FE), remove all linked table and try to Create new link.arnel_gpThanks for your response, arnel. Your advice worked on my testset. Now I will work on the FE with some 20 linked tables.
- Keep in mind that the "linked tables" you see in the Navigation Pane are not the actual tables. They are the names for the connections set up to those actual tables in the back end accdb.
Therefore, the names you see there are aliases for the real tables. You can rename them at will in the Navigation Pane and not have any effect on the names of those real tables where they reside in the back end accdb.
In this case, there was an existing linked table alias, e.g. "tblProduct" or something. When you added a second link to the same back end table, Access used the same alias, but appended the suffix "1", indicating it is a second copy of something with the same name. Both aliases, though, link to the same table in the back end accdb.
