Compact backend of split database

[Tim Cali]

How do I compact the backend of a split database? Does "Compact on close"
automatically handle all of that?

Thanks

 

[Arvin Meyer]

How do I compact the backend of a split database? Does "Compact on close"
automatically handle all of that?

Compact on close only compacts the front-end.

Typically, you would use a maintenance application that fires off using the
Windows scheduler at a predetermined time when you know that nobody will be
in the database. One great product for scheduling compacts is Total Access
Agent:

http://www.fmsinc.com/Products/Agent/index.html

One problem you will have if it is a multi-user system is someone who
"forgets" (I'm being kind here) to log off, thus keeping the database locked
.. For those wonderful users I have some code and a sample application on my
website to Kick Em Off:

http://www.datastrat.com/Code/KickEmOff.txt
http://www.datastrat.com/Download/KickEm.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Shelley]

You can use the JetComp.exe utility on the Microsoft Website. I had a
situation where I had to do manual updates each morning for my
database, so I had all the users log off and I compacted it then. You
can automate it using Windows Scheduler to run at night though.

http://support.microsoft.com/defaul...port/kb/articles/Q273/9/56.ASP&NoWebContent=1

Hope this helps!
Shelley