How do you fix invalid argument when compacting in Access?

N

nick

My database has reached the size limitations but when I go to compact it
gives me a message saying "Invalid Arguements". What is going on and how do I
fix it. Thanks.
 
E

Ed Robichaud

Create a new blank database; import into it ,1/2 of the objects from your
old database. Run compact & repair on the new database, then import the
remaining half of the objects and run compact/repair again. Be sure to
compile the new database (any form/report in design mode, view code,
compile) as well to check for errors.
-Ed
 
Top