Monitor Database Size (1 Viewer)

[dapfeifer]

Hey all,

Is there any way I can monitor the size of the database itself and then perform actions according to how big it is? Example: once it reachs a certain size, pop up a window to suggest running a compact and repair?

Let me know if there's a way!

 

[georgedwilkinson]

Can't you do that in VBA with Dir()? Keep an invisible form with a timer checking it...but be careful about your logic when it "trips". You don't want the user to get multiple messages telling them it's too big before they've had a chance to react.

 

[dapfeifer]

Hadn't thought of that, but then again I'm not a pro with VBA either so that may be why! But thank you for the advice, I will be sure to look into it.