Invalid Argument Access 2003

  • Thread starter Thread starter behrends
  • Start date Start date
B

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
 
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.
Click to expand...

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?
Click to expand...

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]
 
Back
Top