Access compact on close - won't turn off

Hi all,

I have an Access 2010 db in the .accdb format

I turned on the 'compact on close' option for the database

Now I'd like to turn it off

I've gone back into file / options / current database and unckecked the box

but is still runs the compact every time it closes

I've reopend & closed the database multiple times since - it's still compacting on close

Has any one had this issue before?  What's going on??

Who is Participating?
CountryGirlMDAuthor Commented:

I'd only turned on the compact a few weeks ago & I know I didn't add any code to run the compact (and I've searched the code & found nothing)

I've created a new db & imported all the objects from the original db
The new file is working correctly -- no compact on close

but still no clue why the compact didn't turn off on the other file
Rey Obrero (Capricorn1)Commented:
if you are certain that the checkbox (compact on close) is UNCHECK,
check if there are codes that sets the compact on close to true.
CountryGirlMDAuthor Commented:
I am absoulty sure the box is unchecked

I even went back in checked it again - closed the db - reopened & unchecked it again - it's still running the compact on close

and no there is no code turning on the compact
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Have you tried a Compact and Repair?
(JUST kidding!)

OK ... is this a Split db, front end and back end?
And if so ... are you sure you are unchecking the box in the correct db ?

If not, can you upload the db ?

CountryGirlMDAuthor Commented:
yes it is a split db - the problem is in my front end file

yes - I'm sure I'm unkchecking the box in the correct db

can't upload the file with out cleaning out a bunch of proprietary info

i created a blank file and was able to turn the close option on & off and it worked correctly - no compact after the box had been unchecked

my next step is to take a new blank file & import all my local objects & links to rebuild the file
Rey Obrero (Capricorn1)Commented:
<i created a blank file and was able to turn the close option on & off and it worked correctly - no compact after the box had been unchecked>

so it is not your Access program, like what i mentioned  above, some code are turning it on.

it is either a macro or a form event code
Rey Obrero (Capricorn1)Commented:
maybe some gremlins  playing ;-)
CountryGirlMDAuthor Commented:
spliting the points in thanks for the response - but the final solution was to rebuild the file
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.