you might want to try HAL the Handy Access Launcher. It will run certain Access tasks on a scheduler, like launch a macro or compact a database.

This would be very easy to do using some VBA code (a "module" in Access, which you can then run from a "macro"). Basically, query the two tables into Recordsets, and loop through them.

A few best practices can go a long way toward protecting your Access data from careless or overly curious users. Here are some simple ways to add a few layers of security to a database.

Learn how to master Microsoft Access with this comprehensive guide to database management, from core features to advanced tools and best ...