Find size of database?

[Henrootje]

I have a database in which regurlarily tables are being created or
deleted.
This causes a lot of bloating. I set the property that causes the db
to compress and repair at close but my users started complaining.
Loudly.

now I thought it would be a good idea if I could build a check along
the lines:

if database.size 25 mb then compress

I do not know whether it is possible to find the size of a database or
how to find it (from VBA)

Any suggestions?

TIA,

Henro

[paii, Ron]

Move all your temp tables into a "Temp" back end database, private to each
user. You can then recreate the database when the application is opened.

"Henrootje" <He****@gmail.comwrote in message
news:11*********************@s48g2000cws.googlegro ups.com...

I have a database in which regurlarily tables are being created or
deleted.
This causes a lot of bloating. I set the property that causes the db
to compress and repair at close but my users started complaining.
Loudly.

now I thought it would be a good idea if I could build a check along
the lines:

if database.size 25 mb then compress

I do not know whether it is possible to find the size of a database or
how to find it (from VBA)

Any suggestions?

TIA,

Henro

[ManningFan]

It can be done (as described) but doing it in the middle of the day is
not a good idea.

I assume you've got it split into a front end and a back end? I'd
write a seperate DB (or perform a chron job if you have rights) to
compact the front and back ends overnight. If it's bloating so much
that this is not an option, you really need to convince your
supervisors to invest in SQL Server as the back end and keep Access as
the front end.

On Mar 6, 9:06 am, "Henrootje" <[e-mail]:

I have a database in which regurlarily tables are being created or
deleted.
This causes a lot of bloating. I set the property that causes the db
to compress and repair at close but my users started complaining.
Loudly.

now I thought it would be a good idea if I could build a check along
the lines:

if database.size 25 mb then compress

I do not know whether it is possible to find the size of a database or
how to find it (from VBA)

Any suggestions?

TIA,

Henro

[salad]

Henrootje wrote:

I have a database in which regurlarily tables are being created or
deleted.
This causes a lot of bloating. I set the property that causes the db
to compress and repair at close but my users started complaining.
Loudly.

now I thought it would be a good idea if I could build a check along
the lines:

if database.size 25 mb then compress

I do not know whether it is possible to find the size of a database or
how to find it (from VBA)

Any suggestions?

TIA,

Henro

If Filelen(CurrentDB.Name) 25000000 Then