> In Access 97(with linked data tables), is there some reason that
> DBEngine.CompactDatabase in a function works fine (from the open
application
> database) from a command button, but does not seem to work when the same
> function is invoked by a time-of-day event in an open form?  This is
easily
> verified as the Compact creates a new DB.001 file. The previous DB.001
file
> was renamed to DB.002 just before the Compact.  Very strange.
> Thanks