0

Find the actual size of the database?

Jet Reports Historic Posts

June 23, 2008 17:42

None

Follow

I've been able to find the alloted size of the database using =NL("first","Database File","Size (KB)")

What I'm currently unable to find is the amount actually used. I think this information resides in File > Database > Information, but haven't been able to find how to access it through Jet.

The goal is to be able to tell when we reach 90 or 95% of the alloted space and then know that we have to increase the size.

Thanks,

Eric

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts June 23, 2008 17:48

  Are you using SQL Server as the DB of a CSIDE database?

• 0
  
  Jet Reports Historic Posts June 23, 2008 21:29

  I found a solution in the "Table Information" table and the "Size (KB)" field. I summed it up, and added 9% for overhead that seems to be hidden in the structure of the database.

• 0
  
  Jet Reports Historic Posts June 24, 2008 12:54

  If it helps, and if you're using a SQL database, many default options will often autogrow the database and maintain approximately 10% buffer.