hidden tables/hidden msysobjects

[Guest]

When examining a customer's database for a missing table, I tried to import
the table from a spreadsheet and got the message "tablename already exists.
Do you wish to overwrite?" This table is not in the list and, when I went
into MsysObjects (which also isn't visible even when selected make Hidden &
System tables visible), the table had a flag value of 1, along with other
"invisible" tables (and several of the Msys tables). They all have the same
DateUpdate time stamp.

What's going on in there? My collegues and I are at a loss to explain
this... TIA.

 

[Jeff Boyce]

Have you tried creating a new empty db and importing each table and object
into the new (empty) one?

Have you tried using Compact & Repair?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Yes and yes. The table doesn't show up on the object list and
compacting/packing has no effect.

 

[Guest]

You could create an empty DB, import all the objects you can see and then
import the missing table from Excel. Hopefully that will get you back to some
sort of normality...

Steve

 

[Guest]

The date problem might be explained here:
http://support.microsoft.com/kb/299554/en-us

I can't find anything about a Flag of 1. There is a flag for deleted which
should go away with a compact and repair. Those flags are 32 and 3.

I'm wondering if 1 might mean corrupt. I'd make a backup of the database
then do a compact and repair on it. Do the 1 flags go away? Does you missing
table reappear?

You might also try importing all objects into a new database file.

 

[Guest]

At this point it's more of a "WTF is going on here?" situation, intellectual
curiousity rather than an operational issue. Copying the objects into a new
mdb removes the offending tables, since they don't appear in the table list.
We did import the data from Excel using a different name. Just a very strange
situation that none of us had seen before....

 

[Jeff Boyce]

While I'm sure (well, pretty sure) the technical explanation is much more
.... technical, I usually describe a situation like you've described as
"Access getting a chicken bone stuck in its throat".

It's choking, that's for sure, and a good hard smack might be what's
needed...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[George Nicholson]

and a good hard smack might be what's needed...

....just be ready to duck if it decides to smack you back

 

[Guest]

Oh, I'd love to bitchslap Access sometimes...

Anyway, thanx for the input. It's good to know I'm not losing what's left of
my mind. I did rename a table to one of the "disappeared" tables and
everything seems fine.