I have a database that is used mainly for reporting, and I keep deleting and re-importing all the records there.
However every once in a while the database reaches the max size (2GB), and I need to compact it.
The problem is that there are always users connected there and its a big hassle to kick them off.
I would prefer to split the tables into multiple (access) database files, thereby reducing the frequency that it needs to be compacted..
Now my question is, how can I determine how much space does each table consume?