troubleshooting Question

MS Access trouble - backend seems to have odd tables

Avatar of Thomas Zucker-Scharff
Thomas Zucker-ScharffFlag for United States of America asked on
Microsoft OfficeDatabasesMicrosoft Access
12 Comments1 Solution14 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 12 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 12 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004