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 database
Has anyone found a way to 'Compact on Close' in Access97?
-- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Jack Gordon via AccessMonster.com wrote:
Has anyone found a way to 'Compact on Close' in Access97? There is no setting in 97 for this (I wouldn't use it in later versions either). You should be using a split database, in which case you could compact the backend from the frontend using DBEngine.CompactDatabase (look it up in help). As for the frontend, it shouldn't need compacting all that often, but you could add a 'compact' button to your custom toolbar. Users could hit that once a week or so. -- Joan Wild Microsoft Access MVP |
#3
|
|||
|
|||
You could also look at MichKa's TSI SOON (Shut One, Open New) add-in at
http://www.trigeminal.com/utility.asp?ItemID=8#8 -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Joan Wild" wrote in message ... Jack Gordon via AccessMonster.com wrote: Has anyone found a way to 'Compact on Close' in Access97? There is no setting in 97 for this (I wouldn't use it in later versions either). You should be using a split database, in which case you could compact the backend from the frontend using DBEngine.CompactDatabase (look it up in help). As for the frontend, it shouldn't need compacting all that often, but you could add a 'compact' button to your custom toolbar. Users could hit that once a week or so. -- Joan Wild Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Compact & Repair is DANGEROUS! | Mark Burns | General Discussion | 2 | December 9th, 2004 12:50 AM |
Unrecognized database format error after trying to compact & repai | usergn | General Discussion | 3 | December 6th, 2004 10:28 PM |
Converting 97 database to 2003 database and implications | John | Database Design | 1 | November 22nd, 2004 05:23 AM |
compact database in CL | JIM.H. | General Discussion | 2 | September 1st, 2004 01:50 PM |
Please Help, The database is in an unexpected state; Microsoft Access can't open it. | Gary A. Hollenbeck | New Users | 2 | May 20th, 2004 05:42 PM |