Competent Performer
Windows 7 32bit 
Access 2010 32bit
I have just found that "package and sign" unticks - the option compact on close (maybe it's the unpacking that does that but hey)
I have looked at compact and repair by VBA there seems to be a lot of suggestions out there
has anyone had experience here
Thanks
Access Developer
Windows XP Access 2003
Are you sure you want to Compact on close? The following link may be of interest: http://rogersaccessblog.blogspot.co....e-feature.html
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
VIP
Windows 7 64bit Access 2007
Pay particular attention to Roger's fourth point! Paradoxically, as he pointed out, compacting is a recognized cause of corruption and should only be done after making and safely storing a backup copy of the database.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Access db nuked after compact?
Getting my form to close when I close the Report
Posting Permissions
Reply With Quote