I asked another question about this same database here: https://www.experts-exchange.com/questions/29197626/After-making-changes-to-a-backend-my-frontend-seems-only-able-to-access-fields-in-a-temp-table-TMPCLP532891.html,
now I am experiencing a different problem. The frontend of this database is excruciatingly slow (think about 5-10 minutes at best) in loading or in doing anything and I think it is because it is not only linking to 2 different backends (with the same name and structure), one of the BEs has 2 tables that are named as a sequence of numbers and start and end with brackets. When I open the BE that supposedly has these tables, they are not there.
When I look in the FE I see 3 linked tables with funny bracket naming - 2 of these tables seem to have the same data (343 records), while the third has additional data (358 records). All reflect the data in another table, tblDemog (which has 358 records).
Several other items about this Database pair:
- The BE is housed on a network share that is undergoing some repairs
- I use software called AutoFronted Updater to automate updating of the FE of the database and the software is housed on the same share.
- This used to be a single database until I used the built-in splitter to split the database.
- The database frontend has a custom ribbon
I have three basic questions (I actually have way more, but I can probably muddle through some of the others):
- Is there any easy way to determine what dependencies there are on these tables?
- How and why were these tables created in the first place?
- How do I get rid of them?
I just went to relink the backend for another reason and received an error for each of the two tables referenced