Compacting the Database

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.

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/...UBED1=ACCESS-L


"AccessHelp" wrote in message
...
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.

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.

"Roger Carlson" wrote:

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/...UBED1=ACCESS-L


"AccessHelp" wrote in message
...
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.