Access Solutions

How to Transfer the Ownership of an Object in MS Access

In this article, we describe an efficient way to transfer the ownership of an Object in MS Access database. It is important for users to understand and properly use the method of transferring ownership of any given Report or Table etc. in an MS Access database, in order to increase efficiency in the business. By transferring ownership, users can easily transfer information without using any external devices or software like pen drive sharing or email to transfer the data, thus reducing...

Read more »

How Overcome the Size Limits Associated with Access Databases

Learn about the size limits in Access databases, how to deal with them and look at the best ways out. This might come as a surprise to you if you are not a regular MS Access user, but as a matter of fact, there are certain size and other limits in the MS Access database platform. The MS Access 2016 edition provides you with a total space of 2 gigabytes for storing the content as well as the database objects. A single database can provide you with a maximum of 37, 768 objects, 1000 modules,...

Read more »

How to Create a Real-World Disaster Recovery Plan for MS Access

Understand how to create a real world disaster recovery plan to secure you Access databases. As regular Access users you might know the importance of effective backups, and how important it is to frequently backup your Access databases. But in some unfortunate times, you might not be able to recover your backups, or retrieve the complete backups. Or maybe you lost data in a disaster before you could even back it up! In order to deal well with these situations, you would need what is called a...

Read more »