Compacting and Repairing BE when DB is split

  • Thread starter Thread starter T.
  • Start date Start date
T

T.

Hi everyone,

I have a system that is using a split database system with local front ends
and a single server back end. What I would like to have happen is that when
the last user quits the app at the end of the day the backend database will
compact and repair. I have turned on the Compact on Close option in the
Options menu but as the backend is never really "opened" this isn't working.
I have to find a time when there are no users connected and open and close
the backend.

Does anyone have a suggestion as to how I could get this to happen??

Thanks!

T.
 
On my website is a small sample database called "CompactBackEndDB.mdb" which
should get you started.
 
Thanks Roger, this looks really good, but is it safe to run the compact
while other users are connected??
 
You can't. You'll get an error.


Chris

-----Original Message-----
Thanks Roger, this looks really good, but is it safe to run the compact
while other users are connected??

called "CompactBackEndDB.mdb"
which connected and open and
close


.
Click to expand...
 
Just wanted to let everyone know that I did come up with a solution to my
problem.

I found some free VB script that will do the compression for me. I had a VB
developer write a little program that checks to see if the .ldb file exists
and if it does it waits until it is gone and then compresses it, if it
doesn't it compresses and then leaves itself a log with results.

Kind of a creative way around the problem but it is working sweet. I just
leave my PC locked and run task scheduler to do it in the middle of the
night.

Thanks again for all your suggestions.

T.
 
Back
Top