Access Solutions

How to Use Attachment Data Type to Store Multiple Files in a Record in MS Access

In this article, we will learn about the Attachment Data Type field in MS Access, its key details, and how to create a table with attachment data type column. If you needed proof regarding the versatility of MS Access, then here it is. This application might be used for storing small to big amounts of data, but it can also be used for storing different formats of data. Access databases are not just for storing textual or numeric data, but can also be used for storing information that is in...

Read more »

How to Open an Access Database in Systems where MS Access is Not Installed

In this article, we understand how to use Access database in Runtime, without access to the complete Access installation. Although it has been proven time and again that MS Access is the kind of application that is ideal for all kinds of businesses where there is a need for maintaining records and databases.  There are still several organizations and business owners which hesitate from owning the application. Or even if they do own it, they do not wish to install it on every other system in...

Read more »

Why in Some Cases Date Criteria May Not Work in Access Queries?

In this article, we attempt to understand the possible reasons for the date criteria not working, and how to make it work. There are moments when something turns out to be much more complicated than what we would assume it to be. It might have happened with you that you are trying to make use of one of the given functions of MS Access, but are either unable to use it in the best possible way, or are completely unable to use it. One such confusing feature is the Date Criteria in MS Access....

Read more »