Compact Access

[sandrao]

I know that you have the Database compact and repair on closing through
"Access Options." Is it possible to have an option so that a individual
could "compact and Report" when desired and not have to do it through the
option available upon closing. e.g. through VB code with a command button?

sandrao

 

[sandrao]

Thanks a lot

Sandra,
Use the Run Command method to...
DoCmd.RunCommand acCmdCompactDatabase

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

 

[sandrao]

I tried it with a command button and got an error message saying that you
cannot compact a data base when it is open. Now what?