Compacting desktop automatically

My customer uses the old R4 workspace in the N6 client and so the desktop6.ndk grows from day to day for each client installation.My question is: is it possible to compact the desktop programmatically for example with client launch?

I tried using the script db.Compact or db.CompactWithOptions command, but the compact rate is 0%.

Executing the ncompact.exe forces the user to give in the password and besides the result is the same.

Thanks in advance for any ideas.

Regards, Peter

Subject: Compacting desktop automatically

Try using a ‘local db compact script’. I have one that I just pasted into a db. It will compact any database under a certain useage %. On older machines with many local dbs it takes a little while but does the trick nicely.

I imagine that you could have it run on startup, but I havn’t tried.

Subject: RE: Compacting desktop automatically

Thanks for the answer, Jamie.

The local db.compact works fine with other local databases, I have tried it with the bookmarks.nsf. But it does not work with the desktop6.ndk. It finishes after just one second and the compact rate is 0%.

Maybe it’s because if the special structure of the database.

Subject: RE: Compacting desktop automatically

Thanks for the answer, Jamie.

The local db.compact works fine with other local databases, I have tried it with the bookmarks.nsf. But it does not work with the desktop6.ndk. It finishes after just one second and the compact rate is 0%.

Maybe it’s because if the special structure of the database.

Subject: The only way to compact desktop6.ndk when the client is open is to

Right click on an area of the workspace, select Workspace Properties, Pick the propeller head tab and push compact. I don’t think any of the automated ways work while the client is open. the automated way should work when the client is closed.