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 on close?
BlankI have "compact on close" general option set for both my front and
back-end dbs. I do a lot of table add, delete, change activity, from the front-end, on the back-end db. The front-end tables are "linked" to the back-end db, therefore my front end VBA code does not explicitly "open" the back-end, nor does it "close" the back end. Will the back-end db be compacted when I close the front-end db via the "linking" mechanism, or must I use, in the front-end, the compact method in the DbEngine object to get the back-end db compacted? If so, that raises the issue of the back-end being compacted while the front-end is still open; I hope the locking mechanisms take care of that? Thanks Jim |
#2
|
|||
|
|||
Jim,
No, the "Compact on Close" set on your frontend does not compact the backend database. Yes, you can use the DBEngine.CompactDatabase method to compact the backend. Enclosing this in an If...Then to check for the existence of a backend LDB may be sufficient safeguard. -- Steve Schapel, Microsoft Access MVP Jim Shaw wrote: BlankI have "compact on close" general option set for both my front and back-end dbs. I do a lot of table add, delete, change activity, from the front-end, on the back-end db. The front-end tables are "linked" to the back-end db, therefore my front end VBA code does not explicitly "open" the back-end, nor does it "close" the back end. Will the back-end db be compacted when I close the front-end db via the "linking" mechanism, or must I use, in the front-end, the compact method in the DbEngine object to get the back-end db compacted? If so, that raises the issue of the back-end being compacted while the front-end is still open; I hope the locking mechanisms take care of that? Thanks Jim |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
compact on close option | Abbey Normal | General Discussion | 4 | December 31st, 2004 12:49 AM |
Compacting Databases | James C. | General Discussion | 2 | September 15th, 2004 09:59 PM |
Access 97 Compact On Close | doglover | Database Design | 2 | August 27th, 2004 12:22 AM |
Compact on close | Ashley | Database Design | 2 | August 24th, 2004 07:02 PM |
Compact on close | Linda | New Users | 2 | May 21st, 2004 03:00 PM |