Compacting a Database

[OB1too]

Problem.....1.3 gig database....approx 10gig available disk space. Run the compact option..gets almost all the way thru(temporary database is same size as original), and then "falls over" with an insufficient disk space error.
Any ideas??
Thanks

 

[dawnd3]

Are you in the database when you are compacting it? Are you sure you aren't trying to compact it to the A drive or something? This was all that I could think of, sorry if they are silly questions. Dawn

 

[dawnd3]

one more question...are you in 97 or 2000? If in 97, maybe try "repair" before compacting??? Just an idea....

 

[OB1too]

Thanks for the quick response "dawnd3"....
In reply
1. I would assume that if the temporary file is created in the "10gig" drive , that it is the drive the compaction is working with.I have a wander around the settings to see if I can find any other clues...
2. Using Access 2000.

P.S. In running other compactions, I've monitored disk space and noticed that it they chew it up at a great rate.

 

[dawnd3]

Well, I try and help when I can, but I have to admit that I am clueless here.