Access does not autmatically compact a database when you remove records from
a table. This only happens when you rebuild the database. You can do this
in code, although I have never tried it.
There is an article at www.aspfaq.com that shows how to do this in ASP which
is essentially VB script. Take a look at that article and see if you can get
what you need from there.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
