Free articles
Google
Web www.media13.com


Media13.com is a source of free to republish or reprint articles, writers may submit your articles in our database as long so you agree that your article will be freely republish or reprint by other.


Submit Article

Search our database

Received article from us.

Name

Email Address

Friends

Bollywood News
Link building
Article submission service
Freelance Writers
Laser hair removal

We have been looking for freelance writers. Contact us

 


5 Simple Tips to Prevent MS Access Database Corruption   by Kevin Sparks



Having spent many hours fixing Access databases during the past 10 years of my life, I`ve put together this short list of 5 Simple Tips to Prevent MS Access Database Corruption. While the potential causes are numerous, I`ve found that the majority of actual cases can be prevented by following these 5 simple tips.

It`s important to understand that any time an Access client disconnects unexpectedly, it may set a `corruption flag` in the .mdb file indicating that the database is in a corrupt state (regardless of whether any data has actually been corrupted or not). Any user who attempts to open the database while this flag is set will receive a message, and the database will have to be repaired before it can be used. If the users don`t have permission to perform the repair, or don`t know how to perform the repair, there may be significant downtime before the database is available again. This can result in a loss of productivity as well as extreme frustration for the users. Following the 5 tips below will minimize your odds of data loss from corruption in your Access databases.

1) Split your database.


The single most important thing you can do to prevent corruption in MS Access databases is to split the database into a `front-end` and a `back-end`. The front-end contains all of the forms, queries, and reports, while the back-end contains only the data tables. A copy of the front-end is placed on each user`s computer, and the back-end with the table data is stored in a shared folder on the network. How does this prevent corruption? Well, consider the amount of information that must make it across your network to your computer each time you open a form or report. If one bit of that information doesn`t make it intact, you risk corrupting your database. Alternatively, if the forms, queries and reports are all stored on your local computer, then the only bit of information that needs to traverse the network is the actual table data. By reducing the amount of data you need to move back and forth across the network, you significantly reduce the chances of corrupting your database. If you`re having corruption problems with an Access database on a network drive, splitting the database is the single most important thing you can do to stop it.

2) Don`t hold connections open.


This one applies to both programmers and users. If you`re a programmer, make sure you close your connections as soon as possible after using them. Leaving the connections open will allow more opportunities for an `unexpected` dropped connection. The only time you may want to leave a connection open longer than required would when it`s used inside a loop. For such a case, open the connection at the beginning of the loop, and then close it after the loop is completed. Just make sure it gets closed for all cases (including exceptions).

If you`re using a Microsoft Access database or application, be sure to close it when you`re finished. Again, leaving the application open provides the opportunity for corruption if a network connection is lost. Remind users to always close the application before going home, as nightly backup jobs may fail or cause corruption in the shared file if there are open connections.

3) Exit the database correctly.


Always close the database or application correctly. Ctrl-Alt-Delete/End Task can wreak havoc on Access databases. Whenever possible, complete your tasks, then close the application using the File - Exit menu option or alternative Exit option provided by the application.

4) Don`t skimp on hardware.


Remember that the corruption flag can be set from the slightest packet loss between your computer and the database file. MS Access has sometimes been called `the canary in the coal mine`. It has gained this reputation from being the first application to `die` when there`s the slightest hint of trouble on your network. Just like the slightest presence of gas caused the canary to die, the slightest presence of network problems and packet loss can kill your Access applications. Make sure you`re not using the cheap built-in NICs that come with some PCs. Instead, use brand name network cards. The same goes for cheap hubs. Whenever possible, match good brands of equipment throughout your network.

5) Routine compact and repair.


Performing the built-in compact and repair function regularly is recommended to prevent corruption and improve performance. Consider automating this function with a utility to compact and repair all of your databases nightly or during the weekend.

Error messages to look out for - the following error messages may signal database corruption:


`2239 - The database `databasename.mdb` needs to be repaired or isn`t a Microsoft Access database file.`


`Record(s) can`t be read, no read permissions on `databasename.mdb``


`Unexpected Error 35012`


`Unrecognized database format ‘databasename.mdb`.`


`‘databasename.mdb` isn`t an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names.`


`The Microsoft Jet database engine could not find the object `databases`. Make sure the object exists and that you spell its name and path name correctly.`


`The database has been placed in a state by user `<username>` on machine `<machinename>` that prevents it from being opened or locked`


`Disk Error -- Reserved error (-1601)`


`The database has been placed in an unexpected state.`


`Record(s) cannot be read; no read permission on `MSysObjects``


`Record(s) cannot be read; no read permission on `MSysACEs`.`


`The Microsoft Jet database engine cannot find the input table or query `MSysAccessObjects`. Make sure it exists and that its name is spelled correctly.`

Conclusion:


While you may never be able to prevent all Microsoft Access database corruption, you should be able to stop 98% of the problems before they occur by following these 5 simple tips. Follow these tips and implement a prudent automated backup schedule to minimize your odds of significant data loss.

Author Info:

Kevin Sparks is a technical writer for Kaizen Software Solutions, the producer of Digital DBA, an automated MS Access monitoring, backup, and compact/repair utility. For more information, visit their website at http://www.kzsoftware.com/products/digitaldba.


Latest 20 articles

IRS Offer in Compromise – Can It Solve Your IRS Tax Debt Problems? Taking on IRS tax debt is a daunting task that presents many confusing issues. The majority of taxpayers are aware of the option to pay their IRS tax debt in full or pay the tax debt in monthly payments or installments. But there is another option, the IRS “Offer in Compromise.” Knowing the steps to success with an IRS Offer in Compromise, also commonly called IRS tax settlement is important, bec

IRS Tax Debt Settlement Help – When You Need Expert Tax Debt Help With the recent downturn in the economy, Americans find themselves not only facing unsecured credit card debt problems, and difficulties handling their home and vehicle loans, but oftentimes unable to pay their IRS taxes in a timely manner. There is IRS tax debt help available to anyone who finds they owe money for back income taxes to the Internal Revenue Service. The federal government offers

Hidden Dog Fence for your dog Almost everyone who has a pet at home knows value of added exercise and the troublesome task of confining him within the boundaries of their own property. This task is especially difficult with dogs as they take it as a personal challenge to try and defy the fence boundaries. However, you can train your dog to respect his boundaries with the help of an invisible, underground wired dog fence /

Top Dog Containment Solution to make you Worry Free Is your dog driving you crazy? Are you sick of listening to your neighbors’ complaints about your dog running around in their yard? Then you are not alone; almost every pet owner suffers with this problem. Often they confine their dogs to the house due to fears that their dog may wander away. This is a valid fear, as dogs, especially the ones who are new to the house or have not been trained prope

Outdoor Services in Virginia A front lawn is the face of a house and no matter how beautifully you have decorated your house, if your lawn is not beautiful then all your efforts will be useless. It is very important to take care of your lawn because, as it is said, “the first impression is the last impression”. For most people, lawn care is a very tedious task. Most people don’t have the time or energy to spend hours in th

Hidden Dog Fence – Perfect Dog Containment Solution Does your dog refuse to listen to you? Are you tired of telling your dog to not go outside the confines of your house? Does chaining or locking up your dog makes you feel guilty? Is your dog ruining the interior of your house because you cannot let him go in the yard because you are afraid to let him out? Then stop worrying! The perfect solution for all these problems is here. There is a pet co

Debt Settlement: Your Bankruptcy Alternative? There are several different paths you can travel to achieve effective credit card debt reduction and pursue living a debt free life. The method which will be covered here is called debt settlement, and there are numerous debt settlement services to choose from if you determine this is the “debt recovery path” you are going to take. Credit card debt settlement is a credit card debt reduction solu

Los Angeles Brain Injury Lawyers Assist California Motorcycle Accidents Victims Last year over 6,686,147 motorcycles were registered within the United States and the number of registrants has been steadily increasing by at least 7% each year since 2003 according to the NHTSA. Consequently the NHTSA also reported that nation wide last year there were 103,000 motorcycle injuries that did not result in a fatality and California has the second highest motorcycle fatality rate in

Christian Debt Relief: What Are Your Options? Unfortunately, with the downturn in the U.S. economy, credit card debt problems have become one of the biggest challenges facing Christians and their families as they strive to have a healthy financial future. Credit card debt is crippling not just Christians, but all Americans, regardless of faith or race or gender. The good news is that there are Christian debt relief solutions available that c

Christian Alternatives to Bankruptcy – Consider Christian Debt Settlement The recent recession in the U.S. economy has created both employment and financial challenges for Americans and Christian families alike. Credit card debt problems will no doubt reach an all time high as unemployment rates continue to rise. Christians face the reality that filing bankruptcy may be their “only way out”, but that is not necessarily the only workable solution that may be available.

California Brain Injury Lawyers Experienced in Auto Accidents California is one of the most populated states and is known for its traffic congestion. The number of California auto accidents can be daunting. The NHTSA reported that there were 5,987,000 non fatal accidents in 2007; 2,491,000 of those car accidents resulted in injury. The Brain Injury Association estimates that 62 % of all transportation related Brain Injuries occur in an enclosed motor veh

Why Should I Hire a Seattle Real Estate Attorney? In every real estate transaction there are a wide variety of legal issues that must be taken care of. Contracts should always be reviewed by an attorney who understands the nuances of real estate law. But there are also state specific State laws to contend with. A Seattle real estate lawyer deals with a large number of State legal issues related to acquiring, financing, developing, managing, co

California IT Professionals – In Need of California Class Action Attorneys! It is hard to miss the wave of California wage and hour litigation related to California IT professionals and Computer employee overtime that has been sweeping California recently. Even the largest software and computer companies have paid out millions of dollars to employees wrongfully classified as “exempt”, or in other words, not entitled to overtime. A layperson would believe that with pr

Protect Your Mental Health With A Payday Loan Just when you thought that things couldn’t get any worse, more banks went under. More countries are declaring economic crisis. It seems that the world’s financial problems are bound to get worse. Even if you do not have considerable investments in various banks, I am sure that you are feeling the stress that results from these economic upheavals. I sure am. I am just an average person, with a

Free Bulk SMS services People are getting very busy these days without having enough time to talk unless it is very important. Mobile SMS have supported this need to contemporary times as now people do not want to call and enter in the unproductive conversation before coming up to the actual issue. SMS provides you the benefit to come straight to the point and also saves money. What if you get this totally free?

HELP – I Have IRS Levy Problems! If IRS collection notices are ignored, the IRS is forced to collect from taxpayers by force. They do this with their dreaded IRS levy. By law, the IRS has the right to levy bank accounts (IRS bank levy), garnish your paychecks (IRS wage levy), or even seize your assets. But you do not have to let the IRS bully you or your family. There are ways to stop an IRS levy. The first step is to know the

Why Use Professional Tax Debt Help? Good IRS tax relief is hard to find and for people with complicated tax issues, it is an absolute necessity. But how do you know which tax reduction firm is the best one to try? How can you be sure you're going to get the tax debt help that you need? And why is it so vital to receive help from professionals? Settling Your IRS Tax Debt For Less When your IRS tax debt is spiraling out

IRS Settlement – Can You Really Settle Your IRS Tax Debt for Less? It's possible to settle your IRS tax debt, but it presents a challenge. Proving you can settle your tax debt for less is a daunting experience. You have to contend with pages of IRS paperwork rife with technical terms. Settling tax debt is indeed a reality and it can be done. However, there's a lot you need to know before you attempt to settle your IRS tax debt. Rebuking the Lies - The

IRS Tax Relief – The Most Popular IRS Tax Relief Solutions Tax law provides many solutions for resolving tax debt. But if you were to contact the IRS directly, they would only alert you to one solution, and that's paying the tax debt in full. Here are five popular IRS tax relief solutions you should know about to be more informed. IRS Tax Settlement It is possible to settle your IRS tax debt. But there are some pitfalls you need to know. Fi

Hire the California Labor Board or California Labor Law Attorneys - You Decide With a downturn in the economy, many employers are cutting back on payroll. Unfortunately, some employers are reducing payroll costs by violating the California overtime laws. When this occurs, employees have essentially two options to recover their California overtime pay: the California labor board, or hiring California labor law attorneys. Although the California Labor Board is a commonly

Categories
Acne
Advertising
Advice
Aerobics-Cardio
Affiliate Programs
Alternative
Arts
Attraction
Auctions
Audio-Streaming
Autos
Awards
Babies-Toddler
Beauty
Blogging-RSS
Book-Marketing
Branding
Breast-Cervical-Ovarian-Cancer
Broadband-Internet
Build-Muscle
Business
Cancer
Careers-Employment
Casino-Gambling
CGI
Coaching
Coffee
College-University
Colon-Rectal-Cancer
Communications
Computers
Cooking-Tips
Copywriting
Crafts-Hobbies
Creativity
Credit
Cruising-Sailing
CSS
Currency-Trading
Customer-Service
Dating
Debt-Consolidation
Debt-Relief
DHTML
Diabetes
Direct Mail
Divorce
Domain Names
EBooks
ECommerce
Education
Elder-Care
Email-Marketing
Email Entertainment
Entrepreneurialism
Environment
Exercise
Ezine-Marketing
Ezine-Publishing
Family
Finance
Fishing
Fitness
Food
Free
Games
Gardening
Goal-Setting
Golf
Government
Grief-Loss
Hair-Loss
Happiness
Hardware
Health
Hobbies
Holidays
Home-Security
Homes
Home Business
Home Repair
HTML
Humanities
Humor
Innovation
Inspirational
Interior-Decorating
Internet-Marketing
Javascript
Kids And Teens
Landscaping-Gardening
Law
Leadership
Leases-Leasing
Legal
Leukemia
Link Popularity
Loans
Lung-Cancer
Lymphoma-Cancer
Management
Marketing
Marriage-Wedding
Martial-Arts
Medicine
Meditation
Men's-Issues
Metaphysical
MLM
Mobile-Cell-Phone
Mortgage-Refinance
Motivational
Multimedia
Music
Negotiation
Network-Marketing
Networking
News-and-Society
Newsletters
Nutrition
Off-Line Promotion
Online Business
Online Promotion
Organizing
Other
Outdoors
Page Rank
Parenting
Personal-Tech
Pets
Photography
Podcasting
Poetry
Politics
Positive-Attitude
PPC-Advertising
Presentation
Prostate-Cancer
Psychology
Public-Speaking
Publishing
Real-Estate
Recipes
Recreation
Reference
Relationships
Religion
Sales
Sales-Management
Sales-Teleselling
Sales-Training
Satellite-Radio
Satellite-TV
Scams
Science
Security
Self Help
Self Improvement
Sexuality
SE Optimization SE Positioning
SE Tactics
Shopping
Site-Promotion
Site Security
Skin-Cancer
Small-Business
Social Issues
Society
Software
Spam
Spirituality
Sports
Stocks-Mutual-Funds
Strategic-Planning
Stress-Management
Structured-Settlements
Success
Supplements
Taxes
Team-Building
Technology
Teleseminars
Time-Management
Traffic-Building
Traffic Analysis
Travel
Uterine-Cancer
Vacation-Rentals
Video-Conferencing
Video-Streaming
Viral Marketing
VOIP
Web-Development
Webmasters
Web Design
Web Hosting
Weight Loss
Wine-Spirits
Women
Writing
Yoga

Copyright © media13.Com  2005. All Rights Reserved.

Sources : SEO India - Internet web directory