Compact Database

[Kinger43]

There is a command CompactDatabase in the DoCmd.RunCommand action. I tried to use it in a macro to compact my database every so often but it gave me an error saying that you can't compact a database from a macro or VB code. My question is, what is the point of making this command available if you can't use it?

 

[Alc]

I use
DoCmd.RunCommand acCmdCompactDatabase
in a 'Close Form' event and it works fine.

Does it have to be run from a macro?

 

[Kinger43]

I would like it to come from a macro because I already have the macro built and its fairly complicated. I am fairly new to access and have just started really using code instead of umpteen thousand macros and this was one of the first ones I made. It doesn't really matter though because I can write the code and call it from the macro. Maybe it has something to do with the close form event.

 

[Alc]

Just had a quick look around the forum.
Is this any help?
http://www.access-programmers.co.uk/forums/showthread.php?t=123801&highlight=compact+macro

 

[Kinger43]

That helped greatly, thanks Alc

 

[Alc]

That helped greatly, thanks Alc

You're very welcome. Glad to be of assistance.

 

[Moniker]

I love it when my posts from 10 months ago are relevant! (That just doesn't happen too often.)

 

[boblarson]

Just an A2K7 update of that code - Use FMC instead of TDC if you have Access 2007