Compact & Repair Errors

[matzos]

My company runs a Weekly VB program that uploads a lot of information from our older, antiquated system into various mdb's for reporting purposes. Two if the mdb's are quite large prior to compacting. At last upload, one was 555mb and the other was a little over 400mb. Up until last week, this was not a problem to handle. We simply ran a compact & repair and, although it took a while to run, it did the job and reduced the file sizes to the mid-200mb range.

However, the past two weeks have yielded two errors that I can not find any MS help about and have been unable to troubleshoot. The largest file gives an error message reading "Cannot find field 'description'" and the other says "Not Enough Space On Disk" when there is over 2 gbs available to the process.

I did just realize that, apparently, if we move these files to another computer, it seems to compact/repair fine, but the computer that is giving us the errors is the one we must use moving forward.

Any thoughts? I would REALLY appreciate it. Thanks.

 

[Schof]

Your problem is probably that there is "Not Enough Space On Disk". Remember that the original MDB will remain unchanged while a temp one is created for compacting purposes. If you want to make sure that this is not the problem then free up some more disk space and see if you still run into the problem.

Just my 2 cents worth...

 

[deduct]

Check to see if your problem computer is using a different drive for its TEMP space. If so, that may be the drive that is low on space and not the one where the database actually resides (which you say has 2GB free). Karl

 

[lewatkin]

Along with the previous 2 replies, check to see how much network space the user has allocated on the network. I have run into that on a couple of occasions and have had to increase the amount of space that the user has.

Lee