467,075 Members | 997 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,075 developers. It's quick & easy.

Find size of database?

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

Mar 6 '07 #1
  • viewed: 8558
Share:
3 Replies
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

Mar 6 '07 #2
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" <Hen...@gmail.comwrote:
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

Mar 6 '07 #3
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
Mar 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nabhonil Sinha | last post: by
3 posts views Thread by Bob Stearns | last post: by
2 posts views Thread by Josh | last post: by
27 posts views Thread by one man army | last post: by
4 posts views Thread by Henrootje | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.