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!!
Database contents gone
-
- 3StarLounger
- Posts: 254
- Joined: 01 Mar 2010, 17:34
- Location: Blue Springs, MO
Database contents gone
Morgan
-
- Administrator
- Posts: 78678
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Database contents gone
Try the following:
If it doesn't work, I hope that you have a recent backup copy...
- 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 it doesn't work, I hope that you have a recent backup copy...
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 254
- Joined: 01 Mar 2010, 17:34
- Location: Blue Springs, MO
Re: Database contents gone
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.
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.
Morgan
-
- Administrator
- Posts: 78678
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Database contents gone
I fear that your database has become corrupted beyond repair, so you're out of luck. I feel sorry for you!
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 254
- Joined: 01 Mar 2010, 17:34
- Location: Blue Springs, MO
Re: Database contents gone
Not a problem. It was easy enough to recreate what I needed, I had just hoped to avoid that.
Thanks again!
Thanks again!
Morgan