Originally posted by jimpen
Are you trying to compact it into itself? Is it over 500MB? Are you doing the compact over the network?
Access has a 1GB limit and can drop packets easily over a network. Your best bet is to copy the DB local to your machine, compact from one into the other then copy that one back out.
I copied all on my local hard disk, but it gives the same error.
My mainDB only contains forms, queries and modules.
I get my data from 3 other databases (2 on the server and 1 on the clients hard disk)
Maybe it has something to do with that ?
Originally posted by M Owen
I just saw this topic in the MS knowledge base ... Try searching for it there ... www.microsoft.com
I feel stupid.
Everytime I got a problem I'm used to go to this forum.
So I didn't even think of searching the web.
However I did it this time and the problem is solved : my current DB is only 30% in size of what it was before.