By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Access 2000 Compact and Repair Failing

P: 1
Hello all,

I have an Access 2K .mdb file that has grown to capacity (2GB+). I'm attempting a "compact and repair", but I keep getting an invalid argument about halfway through.
I can see a copy of the .mdb file is made but it looks like it stops there.
The error is: Invalid Argument. (Error 3001)

Any help would be appreciated.
Feb 9 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hello all,

I have an Access 2K .mdb file that has grown to capacity (2GB+). I'm attempting a "compact and repair", but I keep getting an invalid argument about halfway through.
I can see a copy of the .mdb file is made but it looks like it stops there.
The error is: Invalid Argument. (Error 3001)

Any help would be appreciated.
I'm moving this question to the Access forum as they will have the answer.

Simple answer though is that 2GB is the limit of the size of an Access database in MS 2000. The easiest solution is to import all of the objects into a new database.

The Access experts may be able to offer futher assistance.
Feb 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.