Forum Discussion
Linking a frontend to a backend
arnel_gpThanks for your response, arnel. Your advice worked on my testset. Now I will work on the FE with some 20 linked tables.
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.George_HepworthThanks for your reaction, George! It gives me the chance to further discuss it: I do not understand the merit of the additional tables added with the number attached in stead of replacing the original BE's path and name with the new one, as it was done in earlier versions of Access. Does anybody know Microsoft's idea about how this additional table could be used?
Also, it would be a good help when the expalantions of the linked table manager would include Arnel's solution when you want to relink to an other BE.
