Database contents gone

[Abraxus]

I have an Access 2003 database.

The other day I was running some code to populate a field in a table and the database size maxed out, giving me the Invalid Argument error.

I stopped the code, and proceeded to compact the database.

It went through the process and where it normally gives you the Cancel, Open, More Info box, I got nothing.

Now when I open the database, still nothing.

The size of the file is right for the contents (180MB) but I can't see anything. F11 does not work. Compacting does not work.

HELP!!

[HansV]

Try the following:

• Create a blank new database.
• Select File | Get External Data | Import...
• Select the problem database and click Import.
• Select all items in all tabs (tables, queries, etc.)
• Click OK.

If this works, you'll have to set the startup options as in the problem database, and if necessary, set references in the Visual Basic Editor (Tools | References...)
If it doesn't work, I hope that you have a recent backup copy...

[Abraxus]

It didn't work (I'd already tried, but tried again)

I have a copy that's recent, but just SLIGHTLY out of date enough for the one thing I REALLY needed this time...

Thanks for the suggestion, though.

[HansV]

I fear that your database has become corrupted beyond repair, so you're out of luck. I feel sorry for you!

[Abraxus]

Not a problem. It was easy enough to recreate what I needed, I had just hoped to avoid that.

Thanks again!