Compacting the backend

[Dan]

Is there any way to have the backend compact
automatically? It would be nice if it would compact on
its own (with out having to be opened and closed or even
touched) when the last front-end is closed.

 

[Roger Carlson]

Is there any way to have the backend compact
automatically? It would be nice if it would compact on
its own (with out having to be opened and closed or even
touched) when the last front-end is closed.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com) is a small Access database
sample called: "CompactBackEndDB.mdb", which shows you how.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L