Compact database setting

[kpfunf]

I've been using the compact database on closing option in my databases. Recently, instead of compacting the current file, on close a new database (sequentially numbered db1, etc.) is created instead. I do not know of any setting change that would have caused this. It does this on multiple databases in different folders. I think they all started doing this at the same time. Any ideas?

[puppydogbuddy]

See this link for one of the most informative articles on compacting & repair that will also provide tips to eliminate the problem you are having. It should answer most, if not all, of your questions.

http://www.msaccesstips.com/2008/06/repairing-compacting-database-with-vba.shtml

[kpfunf]

Thanks for the link.