invalid argument after executing compact/repair

[Guest]

I was trying to create a query when my database locked up. I shut it down and
restarted it. It ballooned from 27MB to over 2G!

I tried to run Compact/Repair but a dialog prompts: "Invalid Argument". I
click "Ok" and the database opens back up without having compacted.

Database corruption? Anyone ever experience this? How can I return my
database back to normal?

Thanks!

 

[Guest]

Others may have better ideas but I would create a new empty database and then
get external data from the old in chunks like this --
Tables
Queries
Forms
Reports
Macros
Modules

I would check each time I got the external data to see if tables were ok,
would compact & repair. Then I would make a backup copy of the database at
that point.

Do the same after the queries, forms, etc. If there is a problem then get
a query or form one at a time untill you know what the error is, bypass it
and continue. Rebuild what could not be brought in due to error.

 

[Bill Mosca, MS Access MVP]

John

Open a blank database and import everything into it, one object type at a
time. That should clean it up.

 

[aaron.kempf]

lose the training wheels.. Access MDB format is completely obsolete.

SPIT on anyone using it for anything

Access Data Projects is a wonderful platform.. you don't have to bounce
a file server to make changes to the database!!

-Aaron

 

[Tony Toews]

I was trying to create a query when my database locked up. I shut it down and
restarted it. It ballooned from 27MB to over 2G!

I suspect it ballooned up and then you got the invalid argument error.
IIIRC that is the standard misleading message when you exceed the 2 Gb
size limit.

Where those append queries?

Importing the objects into a new MDB should fix things up.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[aaron.kempf]

yeah it should fix it up UNTIL NEXT TIME IT HAPPENS

enough is enough

buggy ass software should be thrown away


MDB is *RETARDED*