Tools In Ms Access Databases: Avoid Microsoft Access Corruptions

Tools In Ms Access Databases: Avoid Microsoft Access Corruptions

One of the most popular desktop relational database applications of today, sometimes Microsoft Access can get a little ‘confused‘ causing corruption of which there are tools in MS Access to help manage and keep a handle of your database.

As a result of some corrupted database files, you are either unable to gain access or see data in the consistent format as expected or worse still, keeps crashing when view a particular record.

tools in ms accessThe reasons why Microsoft Access does this are plentiful and is not a detailed discussion within this blog today. More importantly though is how do we handle unexpected corruptions?

Tools In Ms Access Databases: Avoid Microsoft Access Corruptions

Here are my five tips and the tools in MS Access to help avoid and reduce the need to call out a software engineer:

  1. Exiting the application – If you have dedicated forms or a macro call, use it to close the application properly and avoid the CTRL + ALT + DEL method. Exiting also means closing any network connections if sharing a database when reading and writing records across a network and especially if you use VBA code to connect to other servers. An improper disconnection leaves an empty void in the machine’s memory allocation and it is just not a cool thing to do!

  2. Splitting Microsoft Access database – If you share a database over a network where you are bound to have concurrent users, and then consider splitting it into at least two parts. The first part is deemed the ‘back-end‘ and holds just tables (data) on the shared drive (server). The other part; the ‘front-end‘ holds all the other objects locally stored on each user’s PC pointing to the ‘back-end‘. Use the Database Splitter utility to set this up – it’s a breeze to use.

  3. Compact & Repair database – Decide how frequent this task should be carried out (can be daily, weekly, monthly etc.) which simply does two things; compacts the file size to a natural size by squeezing the unwanted air out of an inflated file and then repair any corrupted indexes found resetting keys (including the primary key auto-number counter). This tool is found in the utilities section (varies for different versions).
  4. Backing up (& restoring) databases – This is an obvious utility and simple to use which is in effect a file copy action (as a new file instance). Consider doing this pre and post the Compact & Repair just in case this utility corrupts the database! Always use these tools in MS AccessIf you learn to use back up then the law of averages says you won’t need it!

  5. Analyzer Table – When designing your database, it’s easy to forget setting certain attributes especially for a table and their fields namely indexes. When create relational databases, this becomes and important element in the performance and data integrity and larger volumes of data can take longer to process leading to sometimes a system crash. Use this tool to suggest and recommend what could be added to improve and thus reduce corruptions and in this case indexing is key here!


Tools In Ms Access Databases: Avoid Microsoft Access Corruptions

There you have it, a simple set of suggestions that are often over looked but using the tools in MS Access will help reduce the headaches that some developers experience and then blame Microsoft for.

To learn more about some of these tools and the techniques in building an Access database, take a look at some of my eBooks that I offer (great value! and a money back guarantee too).


This entry was posted in MS Access, Utilities and tagged , , , , . Bookmark the permalink.

3 Responses to Tools In Ms Access Databases: Avoid Microsoft Access Corruptions

  1. Ben says:

    Thank you.
    Never had to result in buying or hiring an Access repair service or kit and therefore cannot endorse your product but happy to offer others this opportunity which again will not take any responsability or credit.

  2. Matt Laurer says:

    Of course these are so helpful tips to avoid corruption in Access database. But, sometimes access database file might be corrupted instead of following these tips. In that case you need a third party Access database repair software:

  3. Ben Beitler says:

    There are of course other tools in MS Access that can run a check on your designed databases one in particular is a general Performance Analyzer which allows to pick not just tables but any other objects to analyse further. Just follow the prompts. you can always re-run this as often as you need to.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.