Minimise Database Size

[JFo]

I need to be able to clear access cache or delete whatever logs/ history it stores for my database (especially when designing to attach to forum but also into the future)

Even if I delete all data from my tables the database keeps growing in size (this leads me to believe access is storing history or logs or a cache of some variety)

The only way I can keep the size down is to export all tables, forms etc to a new database

It is out of control

I did this just now and the same database is 7MB (2.5MB zipped) in the original state and 1MB (126KB Zipped) when I export all tables/ forms/ etc to new database

The inbuilt compact and repair function in access does nothing for me



Thanks

[goodguy]

Open the database in Exclusive mode before comapcting.

[JFo]

Thanks that worked fairly well, not as good as exporting everything to new db but it took it back under 2MB (just)