>Thats done the job - it's shrunk from 100Mb to 86Kb - How on Earth did it get that big in the first place?

Since the database is a VFP table, records get flagged for deletion instead of taken out. Most changes to the database will cause the database to delete records. Recent example - we're merging two databases and improving structures as we go. I just had to add a flag field to every table. This practically doubled the reccount() of my dbc, since it handled it by deleting each table's records (including fields and indexes) and re-adding them +the new one. I guess this is done to better keep the database's indexes in synch.

So, I'm guessing yours got that big because you have been making changes over time and have never packed the database.

Note: Projects (PJX) behave the same way. There is a Clean Up option in the Project menu, just like the database.