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
|
|||
|
|||
Compact back-end database
Hi Folks - Question ... I have a FE and BE Access 2000 database
configuration. If I choose the option to compact on close for the BE database, will it be compacted, or do I need to explicitly open and close the BE db. If so, what techniques are people using to automatically compact the BE db? Thanks. Michael |
#2
|
|||
|
|||
Compact back-end database
I never compact my databases (FE or BE) automatically. However, when I do
want to compact the BE, I use a process similar to my CompactBackEndDB.mdb sample, which you can find he http://www.rogersaccesslibrary.com/f...ts.asp?TID=378 -- --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 "Michael" wrote in message ... Hi Folks - Question ... I have a FE and BE Access 2000 database configuration. If I choose the option to compact on close for the BE database, will it be compacted, or do I need to explicitly open and close the BE db. If so, what techniques are people using to automatically compact the BE db? Thanks. Michael |
#3
|
|||
|
|||
Compact back-end database
Michael wrote:
Hi Folks - Question ... I have a FE and BE Access 2000 database configuration. If I choose the option to compact on close for the BE database, will it be compacted, or do I need to explicitly open and close the BE db. If so, what techniques are people using to automatically compact the BE db? Thanks. Michael Michael, The compact on close only work when the Access EXE file open the database and then closes it. It codes not work on a back end when the front end closes. I normally do not use the compact on close. I find it best to backup a database before the compact/repair is run. Also yo can not compact a back end will there are in users the front end is accessing it. I like to use a scheduled task to ZIP and compact each back end. Here is an example: http://www.peterssoftware.com/cal.htm -- Boyd Trimmell aka HiTechCoach http://www.hitechcoach.com http://www.officeprogramming.com Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|