how to view hidden tables

[pingLeeQuan]

I have a database that is tied to some VB code. Every time I click the database icon (msaccess 97), a form comes up and i start my inventory tracking. I wanted to go look at the tables, but every time I click the "Tables" tab, it tells me "Record is deleted" and does not show me any tables. When i run the inventory tracking again, it comes up fine (no data loss). I went into Tools, options, view tab and enabled all unhidden to be visible but with no avail.

I also held down the shift key to disable all macros on start up of the data base. The same message comes up when I click on the table tab.

How can I make the msaccess show me the tables?

TIA

 

[FancyPrairie]

Make a backup copy of your database, and then try compacting and repairing it.

 

[pingLeeQuan]

Thank you FancyPrairie. Sorry it took too long to respond... thanks again, that worked.