Can't find Table Data

**TeesValleyTech** · 02-22-2018, 08:17 AM

Hi,

Ive been given an Access Database to remove the data so the database can be used from scratch.

The main information is in a "table" called "enquiries" however there is no table called enquiries in the object viewer.

If you go into the relationship manager I can see a lot of "tables" that aren't in the object viewer, where could they be? These tables are also been used in queries

Any help will be much appreciated

**isladogs** · 02-22-2018, 08:35 AM

The tables are probably hidden,
In Navigation pane or database options, change to show hidden tables

**TeesValleyTech** · 02-22-2018, 08:42 AM

I tried that before posting. Thanks anyway

Click image for larger version.

Name: Untitled.png
Views: 11
Size: 49.5 KB
ID: 32700

**isladogs** · 02-22-2018, 08:57 AM

You haven't ticked Show Hidden Objects

Also you have 3 copies of the Enquiries table with suffix 1,2,3.
The table itself could be an alias for another table

**Minty** · 02-22-2018, 08:59 AM

The box isn't ticked to Show Hidden Objects...?

The other option is that they were linked tables in another BE database?

Can't find Table Data

Thread Tools

Can't find Table Data

Similar Threads

Query to find and place data from 1 table to another

Find related data in a table

Find unmatch data from another table with two critreria

Can I use a Find expression to parse data in a Table

Using 'aliases' table as a lookup table to find the primary key 4 'main name' table

Posting Permissions