How Do I Compact Database With an Event Procedure?

[Bill6868]

Is there a simple code to attach to an event procedure to compact a database? I'd like to have the db compact and repair when I click the Exit command button on my form.

Some of the threads I've read are really difficult for my level of programming.

Thanks for any suggestions.

bill6868

 

[LaurieHamlin]

Please post the version of Access you are using.

 

[Bill6868]

LaurieHamlin,

I'm using Access 2007.

Thanks,

Bill

 

[Mhouser83]

I use Office 2010 and found this command
DoCmd.RunCommand acCmdCompactDatabase

But doesn't look like this can be ran from a form button or macro.

Error: You cannot compact the open database by running a macro or Visual Basic code.

Matt

 

[Mhouser83]

I got this working on my database.

VBA code:

'Compact and close the Access Database
DoCmd.CloseDatabase
DoCmd.RunCommand acCmdCompactDatabase

 

[missinglinq]

I got this working on my database.

'Compact and close the Access Database
DoCmd.CloseDatabase
DoCmd.RunCommand acCmdCompactDatabase

If you're going to do that why not simply check the 'Compact on Close' on the Current Database Options?

The problem with all of these is that Compacting a Database has been frequently cited as a cause of corruption, and therefor should not be done without first making a backup copy of the file!


The Missinglinq

Richmond, Virginia

The Devil's in the Details!