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??
HELP!
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??
HELP!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
<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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
maybe some gremlins playing ;-)
ASKER
spliting the points in thanks for the response - but the final solution was to rebuild the file
ASKER
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