Monday, April 28, 2014

Closing a database at a certain time every day

Compacting an Access database is important because it clears out the replaced objects and records and organizes the data according to the primary keys in each table. This can only happen when no one is using the database.

The easiest way to get everyone out of the database is with a macro that runs at a certain time of the day.  You can do this with VBA but if the user doesn't allow VBA to run for security concerns, this won't happen.

and if you want to find out how to easily compact a database, read last weeks post here.

No comments: