Hi - I have an Access 2000 database (~5 MB) and ever since I checked the "compact on close" box a couple weeks ago, the application freezes about 50% of the time I close the db. This happens after all of the open forms are closed, but before the compaction occurs.
Eh?? Anyone know what is going on??
Sometimes this freeze looks like this: the application responds to nothing, other apps work during the freeze, and when I open the task-manager to stop it, it is running 100%.
Other times, the freeze is similar, but the mouse pointer is flashing back and forth from being a pointer to being an hourglass.
It is important for the db to autocompact after use because its size seems to expand enormously (from compacted 5MB to 12 or 15MB after mild use)
Any ideas??? (btw: I tried to search for answers to this on the tek-tips site, but didnt come up with anything-- unclear on what search terms to use-- maybe someone could just tell me: go look at post X or Y)
Much thanks in advance!!
Andy
Eh?? Anyone know what is going on??
Sometimes this freeze looks like this: the application responds to nothing, other apps work during the freeze, and when I open the task-manager to stop it, it is running 100%.
Other times, the freeze is similar, but the mouse pointer is flashing back and forth from being a pointer to being an hourglass.
It is important for the db to autocompact after use because its size seems to expand enormously (from compacted 5MB to 12 or 15MB after mild use)
Any ideas??? (btw: I tried to search for answers to this on the tek-tips site, but didnt come up with anything-- unclear on what search terms to use-- maybe someone could just tell me: go look at post X or Y)
Much thanks in advance!!
Andy