Compacting the Database

[AccessHelp]

Hello all,

I am just wondering what are the steps that you guys take to compact the
database periodically when you have a FE and BE databases and you provide
both databases to the users to use. Do you ask the users to compact the BE
manually, or do you write a code to compact the BE when a user clicks on a
button on the FE?

If you guys use the code to compact the BE, would you mind sharing the code?

Thanks.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CompactBackEndDB.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
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

 

[AccessHelp]

Good morning Roger,

Thanks for your response and your sample database on the compacting. I got
a copy of your sample database from your database.

From your database, would I just need the codes for "Function FindSource()"
and "cmdCompact_Click()" to compact the BE from the FE systematically? Or
which code do you think I need?

I know my questions sound silly. However, I got a little confused on where
to start.

Thanks.