Missing Access Tables

[ZandyRox]

I inherited an access database that has a query with tables that I am unable to locate.

I have unhidden everything.

Is there any other location the tables could be?

[kagoodwin13]

Has the database been split? Maybe it is querying a table in a separate back-end on a network drive? To check, click the "External Data" tab, then click "Linked Table Manager." If there are linked tables to a separate back-end, you'll see where it is saved there. If not, then there is no database split.

Also try changing the objects view. In the Navigation Pane on the left, pull down the filter at the top, and make sure it says "All Access Objects."

[ZandyRox]

Here is a link to the DB

Click here to view

[alansidman]

When I open the db and click on F11, the navigation pane opens and 12 tables are shown which are resident in your db. Should there be more?

[ZandyRox]

Yes, All Access Objects is selected.

[ssanfu]

What tables do you think are missing? (What are the table names)
Or what are the query names with the missing tables?

[ZandyRox]

Theres actually 14. I unhid everything

[kagoodwin13]

When I open the db and click on F11

Thanks for the tip, didn't know that one!

[ZandyRox]

I have a query (qrychanges or qryProjectSummary) that includes tables that I can't locate....challenges with inheriting a database.....
My predecessor created qrychanges.

the names are paid, opportunity, CY commit, commitment...etc


I have a theory that my predecessor might have renamed the "paid" from qry_changes_paid.

[ssanfu]

I have a theory that my predecessor might have renamed the "paid" from qry_changes_paid.

That is what they did. They set an alias on the queries. Open "qryProjectSummary" in design view. Switch to SQL view. Find the FROM clause.
You will see (for example) "......LEFT JOIN qry_changes_installed as installed......"

I know you inherited this dB, but it is in need of rewriting (IMO). There are 6 tables that have the same structure - you could have 1 table with an additional field.
And the PK name problem...

I would also get rid of the lookup fields in the tables. They are a PITA (again IMO).

[ZandyRox]

Thank you.

You're actually the 2nd person to tell me this.

Initially I had wanted to start from scratch, but changed my mind....guess I'm changing my mind again.

[ssanfu]

I think that was me both times.
You had the mdb that was going corrupt.... the combo box was asking for a parameter....

[ZandyRox]

LOL

As for yesterdays problem, as soon as I moved the data from the mdb, it fixed.

I'm already cleaning up the database...in fact, since they hadn't used the database in almost a year, I'm recommending starting from scratch. I love the use of forms/switchboards to keep the look of the db clean...I also use different queries and she used only select...I thought that was weird.