File Recovery

Understanding the Real World Limits of Ms Access and getting the most out of it

In the computing world, striking a balance between user friendliness and performance is a difficult choice to make. Thus software companies typically end up creating different products aimed at distinct target audiences based on their need for ease of use or complex features. In the RDBMS arena, Microsoft has two distinct offerings, the Ms Access application which is essentially targeted at small businesses and the SQL Server application that is targeted at corporate and large organizations. In...

Read more »

Think Before you Choose a Primary Key in Ms Access

The Ms Access application has a wide user base and it includes both professional programmers and average computer users. In fact the number of people, ranging from office executives to small business owners, using the Ms Access database base with very little technical knowledge is considerably high. While using the Ms Access application is extremely easy, the lack of technical knowledge can cause hassle at times. Take the case of selecting a primary key while creating a table to store records....

Read more »

Quick Guide to Backing up your Ms Access Database

In the computing world, backups play a crucial role in protecting your data during unfortunate circumstances. In case of Ms Access, the need to take regular backups is very essential as the application remains vulnerable to several issues. It is a well known fact that Ms Access database has a relatively compact limit of 2GB for most iterations and even if the database size reaches the 1GB figure, it can start to behave inconsistently. Moreover the Access database remains acutely vulnerable to...

Read more »