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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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 ?

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.