Access Solutions

How to Get a Warning When the Number of Records in a Table Reaches a Specific Limit

One of the main reasons people move from using a spread sheet to a database is because the volume of information they’re storing has outgrown what Excel is comfortably capable of handling. But moving to a database doesn’t get rid of that problem completely as database tables have limits for the number of records they can hold too. But how can you know when a table is nearing that limit? Or when it’s simply getting too big and some archiving of data is needed? This article will show...

Read more »

6 Security Vulnerabilities that Can Affect Your Access Database

In this article we take a close look at security threats that one needs to be aware of while running an Ms Access database. Keeping Access Databases safe is one of the top-most concerns of all database users and business users. With the increasing amount of security threats, growing rate of cyber crime and identity frauds, it is very important for an organization to ensure that all its databases are secured from different kinds of attacks. Although so many advanced forms of security threats...

Read more »

How to Link One Access Database to Another

In this article we explore the tricky issue of linking data from one Ms Access Database to another. You might have heard about importing or transferring data from one Access Database to another, it is done often, in a lot of scenarios. But moving ahead of the simple copy / paste technique, today we will be discussing about linking one Access database to another. This too is done in a lot of scenarios, like – when data from one table needs to be shared with data in another table, due to the...

Read more »