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.

Saturday, April 19, 2014

Compacting a database is now as easy as 123

Two months ago I released a new program called 123 for Microsoft Access. I had some comments and on reflection I decided it was too tricky for the average Joe. So I completely rewrote it to be more Office centric and its now called 123 for Microsoft Office and its a lot easier to use. Think of it as a collection of smart shortcuts for your current Office files and databases.

To illustrate how easy it is to compact a database that someone has open, here are the steps to setup a 123 shortcut and Compact the database.

Click on Select a File

Choose a MDB or ACCDB file

Your 123 shortcut looks like this, the people icon displays if database is IN USE

Click Compact. If the database is IN USE, Compacting will be attempted again in 10 minutes

Once everyone leaves the database, it will be Compacted
The next time you open the 123 program, click Compact and it will do it in one step. If it wasn't successful last time, it will click Compact for you automatically.

Check out and download 123 here   If you can, use Internet Explorer to download the program as its easier.

Garry Robinson
Office Access MVP since 2006