Alison Balter's Mastering Access 2002 Enterprise Development

Table and Object Maintenance

You should periodically perform certain audits on the tables and other objects in your database. The main things that you should keep track of are the record count and who has access to an object.

Generally, the amount of data that a table should contain is fairly predictable. It's usually a good idea to keep an eye on the number of records in each table. If the number of records exceeds your limit, you should consider archiving the extra data.

Just as it is important to keep an eye on who has been granted access to the database, it is important to keep track of what permissions users and roles have for each object.