If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Compacting the Database
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. |
#3
|
|||
|
|||
Compacting the Database
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. |
Thread Tools | |
Display Modes | |
|
|