Invalid Argument Access 2003

[behrends]

I get an invalid argument when I open my database. The database is
the front end for a split database. I was working with some large
imports. The file has swelled to over 2 GB. It should be around
50MB. I have tried to repair the DB from inside access and using the
command prompt. I get a corruption error telling me to back up the DB
and repair/compact. I have tried to rebuild the DB by importing to a
blank DB. However, I get the invalid argument and corruption errors.
When I double click on a module, Access tells me it doesn't exist.

I have 40K lines of code and lots of forms and queries to recover.
Any ideas?

TIA

JB38138

 

[John W. Vinson]

I get an invalid argument when I open my database. The database is
the front end for a split database. I was working with some large
imports. The file has swelled to over 2 GB.

That's the maximum size for Access databases, and you WILL get errors.

It should be around
50MB. I have tried to repair the DB from inside access and using the
command prompt. I get a corruption error telling me to back up the DB
and repair/compact. I have tried to rebuild the DB by importing to a
blank DB. However, I get the invalid argument and corruption errors.
When I double click on a module, Access tells me it doesn't exist.

I have 40K lines of code and lots of forms and queries to recover.
Any ideas?

Good luck... I *hope* you made backups, if not routine backups before starting
the imports, at least backups before you tried to repair and compact. It's
quite possible that compacting a damaged but salvagable database could destroy
it permanently.

See Tony's corruption FAQ at

http://www.granite.ab.ca/access/corruptmdbs.htm

for suggestions, including links to database salvage services.

And... keep current backups. Access is reasonably robust, but databases CAN
become irretrievably corrupt or damaged; the only database which doesn't need
backups is one that you don't mind rebuilding from scratch at the most
inconvenient imaginable time.


John W. Vinson [MVP]

 

[newsgroups]

Hey there,

Saw that you did a compact and repair with the open database, and then
from the command prompt, also. It may be duplicating the command
prompt c&r, but have you tried compact and repair on the closed
database via Access?

Step by step instructions are at:
http://www.seehowrightnow.com/video_tutorials/access/access_2003/tutorial.asp?vidnum=AC030406


HTH!
Crystal
Microsoft Certified Instructor-Office 2000/XP/2003