Finding Database Size

[cforce]

Hello,

I'm wondering if anyone might be able to help me out with this. I have searched message boards for hours, but to no avail. I'm trying to find a way to set up a process that will (automatically) send a notification e-mail from access when the database is nearing it's 2GB limit. I discovered how to send e-mails through a macro, but I have no idea how to get the database size through either a macro or a module. Has anyone had success with anything like this in the past?

Thanks!

 

[doulostheou]

From VBA Help:

FileLen Function

Returns a Long specifying the length of a file in bytes.

Syntax:
FileLen(pathname)

The required pathname argument is a string expression that specifies a file. The pathname may include the directory or folder, and the drive.

Remarks:
If the specified file is open when the FileLen function is called, the value returned represents the size of the file immediately before it was opened.

Note To obtain the length of an open file, use the LOF function.