compact db

  • Thread starter Thread starter Basil
  • Start date Start date
B

Basil

Hiya, I put a reply to a post a bit down there Re:"SQL
this time" which has more info. I thought I'd neaten up my
query here.

Is there a way that you can script an event in VBA to
automatically compact the current database? Or otherwise
force the user to do so?

The reason for the need is that when I import some data
and run delete and append queries to put them in existing
tables it takes the DB from 15MB to 150MB. If there was a
way to get Access to not do this then I wouldn't need the
compact DB solution.

Thanks so much for any advice.

Basil
 
Thanks Doug. Is there a way that I can stop the database
being sized up so dramatically with the delete/append
queries? If no singular method, any tips on keeping size
down in such a process?

Thanks,

Basil
 
If you use A2K0 or higher, try the Compact-On-Close option. No code is
needed with Compact-On-Close.
 
Unfortunately this place is stuck in the dark ages and I
am stuck with Access 97.

Thanks though.
 
Back
Top