Compact database setting

Question posted by: kpfunf (Member) on July 24th, 2008 12:30 PM

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

Expert

1,665 Posts

July 25th, 2008
03:47 AM
#2

Re: Compact database setting

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...-with-vba.shtml

kpfunf

Member

73 Posts

July 25th, 2008
12:54 PM
#3

Re: Compact database setting

Thanks for the link.

Not the answer you were looking for? Post your question . . .
190,081 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Top Microsoft Access / VBA Forum Contributors