Database size

[Mcgrco]

When my database opens up I want a piece of code that tells the user what size the database is. Ultimatly i want to warn the user when the database goes over a set size to compact it.


Thanks

 

[PearlGI]

Use the FileLen function.

HTH

 

[Mcgrco]

I cant get the file len to work . it keeps coming up with an overflow message.

the code Im using is
Function size()

Dim DBsize As Byte


DBsize = FileLen("C:\Program Files\calers\uat\calers.mdb")
MsgBox DBsize


End Function

 

[PearlGI]

DBsize should be defined as LONG, not BYTE.