MS Access Table missing

[Dima S]

Guys,

I'm looking at a database (Access2003) someone sent me and I see a Query,
something like SELECT * FROM [Table 1]

The problem is that there is no [Table 1] in table list, query list. In
fact, there is no such object with the structure that I see when I open that
original Query a=in design mode. The query opens and shows data....

Any thoughts?

Few more observations: looks like this DB was converted before with errors;
thiis DB uses linked tables

Thanks!

Dima.

 

[Linq Adams via AccessMonster.com]

Assuming that this isn't a split database (do any forms show up?) with the
tables in a separate back end, goto

Tools - Options - View

and see if "Show Hidden Objects" is checked. If not, tick the box and see if
the table now shows up.

 

[Stuart McCall]

Guys,

I'm looking at a database (Access2003) someone sent me and I see a Query,
something like SELECT * FROM [Table 1]

The problem is that there is no [Table 1] in table list, query list. In
fact, there is no such object with the structure that I see when I open
that
original Query a=in design mode. The query opens and shows data....

Any thoughts?

Few more observations: looks like this DB was converted before with
errors;
thiis DB uses linked tables

Thanks!

Dima.

In addition to Linq's advice, make sure the table links have their connect
properties set correctly. If the BE is in a different location to the db's
owner, the connects will be wrong. Use Linked Table Manager to set them
correctly.

 

[John Spencer]

If you switch to SQL view do you see Table 1 in the FROM clause

It is possible that a valid table has been aliased. IN SQL it would look like

SELECT ...
FROM MyNamedTable as [Table 1]
WHERE ....

OR

SELECT ...
FROM MyNamedTable [Table 1]
WHERE ....

The AS is optional although I always use it since it makes it clearer that the
table instance has been assigned a different name. Same table just like I am
the same person even when I am referred to as John, Spence, JP, or Pappap
(grandkids).


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Guys,

I'm looking at a database (Access2003) someone sent me and I see a Query,
something like SELECT * FROM [Table 1]

The problem is that there is no [Table 1] in table list, query list. In
fact, there is no such object with the structure that I see when I open
that
original Query a=in design mode. The query opens and shows data....

Any thoughts?

Few more observations: looks like this DB was converted before with
errors;
thiis DB uses linked tables

Thanks!

Dima.

In addition to Linq's advice, make sure the table links have their connect
properties set correctly. If the BE is in a different location to the db's
owner, the connects will be wrong. Use Linked Table Manager to set them
correctly.

 

[John W. Vinson]

The AS is optional although I always use it since it makes it clearer that the
table instance has been assigned a different name. Same table just like I am
the same person even when I am referred to as John, Spence, JP, or Pappap
(grandkids).

"You can call me anything you want... just don't call me late for dinner!"