On Fri, 30 Jun 2006 22:13:44 -0500, Gene Wheeler <[EMAIL PROTECTED]> wrote:
> The data file runs around 40MB >in file size. When I compact it, that brings it down to 17MB. If I >open the file and make a few changes then save it, it immediately >bloats up to 40MB again. If I compact it, back down to 17MB. What gives?? After you compact, make sure you refresh (F5) the Windows Explorer display that you are looking at to determine the file size. When I do a compact only, my filesize drops from 39MB to 13MB, then immediately jumps back to 39MB. My guess is that compact, which is an MS Access thing and not a Legacy thing, at some point drops and rebuilds the indices. When you see the file size dip to 17MB, you are looking at the database after the indices have been dropped, but before they have been rebuilt. After compact finishes and before you do anything else in your database, try hitting F5 in Windows Explorer and see if the filesize doesn't go back to 40MB. -- Dennis M. Kowallek [EMAIL PROTECTED] (P.S. Postings w/attachments or in HTML format automatically killfiled.) ****************** Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ For online technical support, please visit http://www.LegacyFamilyTree.com/Help.asp To unsubscribe please visit: http://www.LegacyFamilyTree.com/LegacyLists.asp