Hi all,
I have a situation where the backend of my database has thousands of
records pasted and deleted hourly. Because of this, the size it getting up
to around 100mb when after compacting goes back down to around 16mb. The
only time I can compact this is when everyone has logged out of the frontend
which doesn't happen too often. I have tried deleting the record locking
file .lbd but as the backend is in use, it will not delete.
I cannot find any way of 'forcing' the compact whilst people are using the
frontend other than finding everyone using it and asking them to logout.
The network is spread over quite a large area so this is not really
practical.
Is there a way I can force them out or get the backend to compact
automatically as soon as no-one is logged in?
Your help will be much appreciated.
Mark