Missing tables and forms............but not really!!

jayhart

Im having an issue with a database where Im missing tables and
forms............but they still seem to be present (but not
displayed).
When Im looking at the table list, the table is not listed (table name
"tblMain"), but Im able to run an existing query (and I get results)
off this "phantom" "tblMain" table. It's as if the query is running
off a table that doesn't exist. But if Im receiving results, the
table has to be somewhere, right?

Ive talked to numerous IT staff (much more educated in Access than
myself) and they have never seen this before.

Is there anyone that can explain this? And if so, is there a fix?

Thanks
Jason

Aug 6 '08 #1

jayhart

On Aug 6, 3:38*pm, jayh...@verizon.net wrote:

Im having an issue with a database where Im missing tables and
forms............but they still seem to be present (but not
displayed).
When Im looking at the table list, the table is not listed (table name
"tblMain"), but Im able to run an existing query (and I get results)
off this "phantom" "tblMain" table. *It's as if the query is running
off a table that doesn't exist. *But if Im receiving results, the
table has to be somewhere, right?

Ive talked to numerous IT staff (much more educated in Access than
myself) and they have never seen this before.

Is there anyone that can explain this? *And if so, is there a fix?

Thanks
Jason

BTW, Im using MS Access 2002

Aug 6 '08 #2

Chris O'C via AccessMonster.com

One of three choices. Click on menu Tools Options. On the View tab, mark
the "Show hidden objects" check box. Your hidden objects will appear in the
db window. This is the most likely choice, and it's very, very common. Your
IT department should know this one.

Second choice is it's a system object. "Show system objects" is right below
the "Show hidden objects" check box in Tools Options. Mark that one and
see if the missing tables show up. This usually requires a name of an object
starting with Usys or Msys.

Third choice you can read the path of the db that has the table and query in
the form's record source or the table in a query's properties when in design
view.

Chris
Microsoft MVP
ja*****@verizon.net wrote:

>Im having an issue with a database where Im missing tables and
forms............but they still seem to be present (but not
displayed).
When Im looking at the table list, the table is not listed (table name
"tblMain"), but Im able to run an existing query (and I get results)
off this "phantom" "tblMain" table. It's as if the query is running
off a table that doesn't exist. But if Im receiving results, the
table has to be somewhere, right?

Ive talked to numerous IT staff (much more educated in Access than
myself) and they have never seen this before.

Is there anyone that can explain this? And if so, is there a fix?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

Aug 6 '08 #3

fredg

On Wed, 6 Aug 2008 12:38:46 -0700 (PDT), ja*****@verizon.net wrote:

Im having an issue with a database where Im missing tables and
forms............but they still seem to be present (but not
displayed).
When Im looking at the table list, the table is not listed (table name
"tblMain"), but Im able to run an existing query (and I get results)
off this "phantom" "tblMain" table. It's as if the query is running
off a table that doesn't exist. But if Im receiving results, the
table has to be somewhere, right?

Ive talked to numerous IT staff (much more educated in Access than
myself) and they have never seen this before.

Is there anyone that can explain this? And if so, is there a fix?

Thanks
Jason

Most likely, that table (and perhaps other tables and forms) has been
intentionally hidden, most likely to prevent anyone from seeing it and
therefore tampering with it's data. Tables are for storing data, not
for data viewing nor entry.

To view the database's hidden objects, click on
Tools + Options + View
Place a check in the View Hidden Objects box.
Click OK.

The table should now be seen in the main database folder.

When done with viewing these objects, go back to options and remove
the check from the Hidden objects box.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Aug 6 '08 #4