Compact Access

[Guest]

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

 

[Al Campagna]

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

 

[Guest]

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

 

[Guest]

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?

 

[Al Campagna]

Sandra,
Try http://www.mvps.org/access/general/gen0013.htm
It has good info on why you have the problem... and some workarounds.
I have not personally tried the suggested workarounds, but it should be
worth a try.
--
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."