Compacting a backend Acess 2002

[Mark Reed]

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

[Tom van Stiphout]

On Thu, 8 Apr 2004 07:41:36 +0100, "Mark Reed"
<ma*********@ntlworld.com> wrote:
You could write a separate app that monitors the existence of the LDB
file, for instance every time a timer tick occurs. Additionally you
could have Idle detection code in your app, that shuts down the app
after some time of non-activity. Or you could migrate to a database
like SQL Server that does not require compacts.

-Tom.

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

[Lyle Fairfield]

"Mark Reed" <ma*********@ntlworld.com> wrote in
news:Pt6dc.12$Xc6.8@newsfe1-win:

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

I believe the code found at
http://ffdba.com/downloads.htm
as
Compact MDB of Linked Tables
will effect this. You could try putting it in a form's module and setting the
form's timer event to try it every whatever, 5 seconds or 5 minutes. If you
link to one table in your be, you could use a separate db altogether.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)