Access Database Repair Blog

How to reduce Access database corruption 2

Here is the continuation of my previous post. To recap, I’ve already discussed the advantages of using good quality network hardware. For this entry, I shall now discuss a truly effective way to minimize data corruption in your workplace. What is that, you ask. It’s very simple and highly recommended.

Workstations that are joined by a network share files. If there are more files being shared than necessary, there’s a higher possibility of database corruption. For example, a report that’s only needed by one person is being worked on, and suddenly, for some reason, the computer of the person working on it freezes. He starts pressing different kinds of keys and then in frustration, hits the restart button. Then chaos happens.

This situation could have been prevented if the report is stored only in the workstation of the person using it. Since all of the objects are being shared in the network, there is a higher risk of corruption and increased need for Access repair because of incidents similar to my example.

So, how do we prevent such situations?

Split your database into a front-end and back-end.

What goes to the front-end and back-end? For the objects that don’t really need to be shared over the network such as forms, queries, and reports, they go to the front-end. These objects are mostly used individually, so it’s best to store them in local computers. Tables, on the other hand, store information that everyone needs to make reports, queries, and so on. Tables should be stored in the back-end of your Access database, because these are objects that are used by lots of people.

Once the data shared over the network is minimized in this manner, your database will be safer and will require less Access recovery.

Dieser Beitrag wurde am Tuesday, 18. September 2007 um 13:39 Uhr veröffentlicht und wurde unter der Kategorie MS Access Corruption abgelegt. Du kannst die Kommentare zu diesen Eintrag durch den RSS-Feed verfolgen. Du hast die Möglichkeit einen Kommentar zu hinterlassen, oder einen Trackback von deinem Weblog zu senden.

«  –  »

No Comments »

No comments yet.

Leave a comment

You must be logged in to post a comment.







WP-Design: Vlad -- Powered by WordPress -- XHTML 1.0