I am going to run code that automaticly runs a series of action queries to
update and make tables on the BE, which is currently ran on the FE. In this
code, once the queries are finished, I want the BE to close to compact daily
as the application seems to blow up to over 2 gigs and cause errors without
this bit of maintenance after a couple of weeks. With compacting the
application is usually about 299 MB. I believe this excessive growth is due
to running these queries on the FE daily or more than daily on multiple
remotes. The queries are very intensive running up to 27 lines of code for
each record (thousands of records).   I have already posted and this seems to
be the best way to  extract "like" string quries and convert the extracted
value to another text. Other than that, the problem I have is when closing
the BE to be compacted, some work stations are lift on inactive and prohibit
the BE from compacting. Ours is a 24 hour operation, but at 5:20 AM no one is
actually using the system employees just don't back out of their forms
keeping records engauged. What I thought I could do is have a timer form
hidden on each one of the FE and to close the application say 5 to 10
minitues before the compacting begins. The question I have is, is this a good
idea or faulty thinking?

Thanks,
Dennis