Is it possible to compact a database within a macro in Access 97?And if so, how?TIA,CJK ...

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 ...