Do other developers have experience of Access dumping tables?

[Chrisso]

Hi All

I had a table with two fields only. One field was text where I
recorded username and the other field long number to hold primary keys
of objects of interest to the user when they click in list boxes. This
way I can keep track of which records my users are interested in
through using the list boxes.

I am currently developing this database and was the only user. An
error occurred of some sort when my code was running delete and append
queries on this table (after working fine for 1.5 days) and Access has
seemed to dump the table! It no longer can be seen in the tables
window!

Do other developers have experience of Access dumping tables?

Is this just bad luck or have I done something wrong in my design
(which is very simple) to cause this? Can unhandled VB errors result
in Access dropping a table?

Any thoughts would be of help becuase I have to decide whether to
abandon this approach.

Cheers
Chrisso

 

[Jerry Whittle]

Check to see if there are scroll bars in the database window. It might just
be a little off screen....

Next on the menu go to Tools, Options, View tab and select both Hidden and
System objects. It's possible that it got hidden away.

After that you might have accidentely dropped the table.

Lastly try doing a Compact and Repair. The database might have been
corrupted somehow.

If none of the above work, you'll have to resort to your most recent backup.
You do have a recent backup, don't you? If not, you may be learning a sad,
but valuable lesson the hard way.