[AccessD] ...monitoring be mdb size

Hi William
Only just spotted this. You've probably done it by now, but..

I have an MDB which runs on a nightly schedule. What it does is slightly
different from yours in that it measures the difference in size between the
the live BE (well a copy actually) and one which it Compacts. It then emails
me telling me by how much the BE would shrink if I threw everyone out of the
system to run a compact. It's only a few lines of code and nothing you
couldn't do in your sleep but you're welcome to it if it's any use.

--
Andy Lacey
http://www.minstersystems.co.uk

> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> William Hindman
> Sent: 31 March 2007 22:23
> To: Access Developers discussion and problem solving
> Subject: [AccessD] ...monitoring be mdb size
>
>
> ...I want to monitor the size of my be mdb's and gen an
> e-mail if they grow
> by a certain percentage in a given time frame ...has anyone
> already done
> this and have a solution they're willing to share?
>
> William Hindman
>


________________________________________________
Message sent using UebiMiau 2.7.2