Can't See Tables (or anything else)

J

John Schneider

My sister runs a small company and has been using an Access database for a
couple of years. She is currently running Access 2002. This morning, she
tried to open the database (she uses it multiple times every day), but
nothing shows up. I VNC'd to her PC and confirmed that the mdb file is
there, but when I open it in Access, the screen is blank. If I go to
View|Database Objects|Tables, nothing shows up on the screen. Of course, she
says "it was fine yesterday, and I haven't changed a thing!"

If I go to the File menu, the options such as Close, Save As, etc are
accessible, which shows that the database is indeed open. I just downloaded
the mdb file to my PC, running Access 2003 SP1, and still have the same
problem.

I've looked through the KB and newsgroup postings, but can't find anything
helpful.

Thanks for ANY ideas as to what is wrong!
 
M

Madhuri

Check the size of the database if its around 92 Kb then the database has
lost all tables else there should be something else wrong with it..

Madhuri
 
J

John Schneider

The size is 1,412KB

Madhuri said:
Check the size of the database if its around 92 Kb then the database has
lost all tables else there should be something else wrong with it..

Madhuri
Click to expand...
 
M

Madhuri

Your database might be intact then.. try repairing the database from the menu
given and try to view the tables again

Madhuri
 
M

Mike Labosh

The size is 1,412KB

Try a Repair / Compact, and then look at the file size again. Then open it
and see if anything magically appeared. If not, goto Tools -> Options and
check the boxes to show hidden / system objects and click OK. If you can
see the system tables and not your tables, I hope you have a backup.

--
Peace & happy computing,

Mike Labosh, MCSD
"Working here is like living inside a Salvador Dali painting." -- Me. Yeah,
ME! [Oh fer cryin out loud]
 
J

John Schneider

"Been there, done that"... I tried all that stuff, but still no go.

I finally fixed the problem, although I don't know how this happened. As I
said, when I open the database, the screen is blank. I just noticed the
sliders on the right edge and bottom of the screen. I moved the right slider
all the way down, and it dissapeared. I then moved the bottom slider all the
way to the right, and it dissapeared. Lo and behold, there in the bottom
right corner of the screen was the minimized database. I have no clue how
she did this, but at least its working now.

Wierd, eh?

Thanks again for everyone's responses.
John

Mike Labosh said:
The size is 1,412KB
Click to expand...

Try a Repair / Compact, and then look at the file size again. Then open it
and see if anything magically appeared. If not, goto Tools -> Options and
check the boxes to show hidden / system objects and click OK. If you can
see the system tables and not your tables, I hope you have a backup.

--
Peace & happy computing,

Mike Labosh, MCSD
"Working here is like living inside a Salvador Dali painting." -- Me. Yeah,
ME! [Oh fer cryin out loud]
Click to expand...
 
V

Van T. Dinh

Always check the Scrollbars. You are not seeing the whole application
window on screen if the Scrollbars appear.

In addition, the Database Containers window sometimes moves off the
application window and leave just 1 tiny bit on the window which will be
hard to detect.

Either way, you can always use the Menu Windows / Cascade to move the
Database Containers window (and other object windows) to the visible area.
 
Top