In the "Set Options from Visual Basic" Help topic in the Microsoft Access 2000 Visual Basic Editor, under the "General Tab" information, there is a feature listed that is called "Compact when database will shrink by this percentage or more." The string argument of "Auto Compact Percentage" can be changed by using the SetOption
method in Visual Basic for Applications. This feature should compact an Access database (.mdb) or an Access project (.adp) only when the file would shrink by the specified percentage or more.
The Help file is incorrect. The Auto Compact Percentage feature can be set by using SetOption
and retrieved by using GetOption
; however, the value is ignored by Access 2000. The compact is completed, regardless of the percentage value.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.