i don't suggest turning 'compact on close' off i think it may put the data more in harms way than out of it
20M files turn into 5M (recycle bin status aside) so there is obviously a lot of dross in there after a bit of work
even if you don't care about storage space the compact is like a maintenance issue
ds
_______________________________________________________________________ Integrated Controls, Inc. Tel: 415-647-0480 EXT 107 2851 21st Street Fax: 415-647-3003 San Francisco, CA 94110 www.integratedcontrolsinc.com
[EMAIL PROTECTED] wrote:
In a message dated 2005-03-31 10:46:27 PM Eastern Standard Time, [EMAIL PROTECTED] writes:
A few months ago (maybe even a year or so), I started having difficulty with 99se SP6 when it compacts a certain databases. 99se simply stops responding during the compact process and I have to use task manager to end the application. I can usually see when this is happening because the progress bar on the status line goes to 100% and clears much quicker than normal. At that point 99se no longer responds and the database will never successfully compact again (even if I delete the temporary .cmp database).
If I start a brand new database or use different database, the compacting functions normally. But if I move files from database that will no longer compact to a new database, the new database will not compact either.
The thing that seems to trigger the compacting failure is deleting certain .pcb or .lib files in the database (moving them to the recycle bin is not a problem, it's only when the bin is emptied or files are deleted [eg. shift-delete] without going to the bin that the compact failure occurs).
I've spent many hours trying to figure this one out. Has anybody else experienced this problem? Does anyone know of a way to fix files & or databases that stop compacting?
I've seen the same behavior, but hadn't linked it to deleting files. I've turned off "compact on close" for exactly this reason. I generally only compact the files when preparing to email them or archiving. Any hints would be welcome.
Steve Hendrix
____________________________________________________________
You are subscribed to the PEDA discussion forum
To Post messages: mailto:[email protected]
Unsubscribe and Other Options: http://techservinc.com/mailman/listinfo/peda_techservinc.com
Browse or Search Old Archives (2001-2004):
http://www.mail-archive.com/[email protected]
Browse or Search Current Archives (2004-Current):
http://www.mail-archive.com/[email protected]
____________________________________________________________ You are subscribed to the PEDA discussion forum
To Post messages: mailto:[email protected]
Unsubscribe and Other Options: http://techservinc.com/mailman/listinfo/peda_techservinc.com
Browse or Search Old Archives (2001-2004): http://www.mail-archive.com/[email protected]
Browse or Search Current Archives (2004-Current): http://www.mail-archive.com/[email protected]
