Access Database Recovery

How to Use Temporary Tables for Negotiating Non-Updatable Queries in MS Access

In this solution, we look at a non-programmatic way to deal with non-updatable queries in MS Access using Temporary tables  Queries in MS Access are one of the essential features provided by the application. If you take away the query feature from MS Access, there would be very little left in the application. Access provides its users with multiple types of queries that can be used in multiple situations. However, these queries also have their own set of limitations. The most annoying one...

Read more »

How to Quickly Create a Macro Group in MS Access

In this article, we attempt at creating a Macro Group in MS Access instead of creating several standalone macros. Macros in MS Access allow you to automate actions. You can opt for creating a macro to get a particular task done. You might also want to create group macros which can be used for automating the related task to the one that you have automated. If you are making use of the 2007 edition of MS Access, you will have the option of using the macro objects for containing the macros that...

Read more »

How to Assign and Change Default Permissions in MS Access

This article addresses an effective method using which users can learn to Assign Default Permissions and Change Them in MS Access. By Assigning default permission on their databases, users can limit and manage the accessibility of their resources. Restricting permission also helps in making your database more secure and manageable. The user can assign permission based on different groups or departments in the company, rather than assigning permission to each user for every object...

Read more »