What causes a broken link? As discussed in What is a split database, a well designed Access database usually has a back-end data file and a front-end interface file. The back-end data file contains the data tables, and the front-end…
Divide and Conquer This Thursday is Thanksgiving in the US. There will be much to do. Someone has to prepare the turkey, and then someone has to cook it. Someone has to wash and peel potatoes before they are mashed…
What is an input mask? An input mask is like a face mask. A face mask covers the opening (mouth) that otherwise would allow bad things into the human body. An input mask is similar. It acts like a mask…
According to the Oxford dictionary a field is “an area of open land, especially one planted with crops or pasture, typically bounded by hedges or fences.” A farmer may have many fields; some that grow cotton, others that grow corn,…
Where did that name come from? As you work with computers, you come across terms that make you wonder how they got their names. For example, why is the main circuit board of your computer called a "motherboard"? Or why…
Logging Events How do you keep track of the things you are supposed to do? Do you find that sometimes you do the same important things multiple times because you forgot that you had already done it? Worse, what happens…
The Problem Access databases are designed to grow as they are used. As additional records are added the database grows. By design, when records are deleted, the space allocated for those records is not recovered. Consequently, the backend database periodically…