Corrupt Database?

[echoecho]

I have a mdb file that shows it is 135mb in size. However, when I open it there are no tables, queries etc etc. I have tried compact/repair and the file size stays the same. I have tried making new tables in the database and it works, but after I save and close it, it does not visible to open. any ideas greatly appreciated

 

[markphsd]

Export everything useful out of the db into a blank db, see if it bloats the new one. That should work. Sometime's db's go bad and its more effort to fix the problem then to avoid the problem.

 

[DonQuichote]

Tables can be hidden. if you type the following code in the debug window (ctrl-G to show the window):

? currentdb.tabledefs.count

You will see how much tables there really are in the database. There are some 10 to 15 system tables in each mdb (don't know the exact number), but you can make your own tables invisible as well.

Best regards