Tech

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.

Spyware elimination software is designed to detect and eliminate spyware. A large number of spyware elimination software products are available. Some of them are available as freeware and some as shareware. Shareware can be used for a specified period, usually 30 days.

One must evaluate and compare the features of different spyware elimination software products before selecting one. Some of the features of an effective spyware elimination software product are:

* It should give a list of detected spyware, to enable users to allow them to decide, about which ones they want to delete.

* Auto update ensures that the software automatically downloads the latest spyware definition file.

* Auto scheduling means that the system is scanned for spyware at defined intervals automatically.

* The “undo” facility allows the user to remedy accidental deletion of useful files.

* The product should provide real-time protection. It should prevent installation of spyware, instead of just deleting it when it is detected.

* The software should be effective in detecting and deleting, the different types of spyware.

* The product should be easy to download, install, navigate and use.

Your customer data is a precious resource that can literally be worth its weight in gold! If used properly, it can be mined over and over for additional sales and referrals. Do you use this gold mine to increase the profitability of your business?

You should! It can mean the difference between business survival and failure.

Why then do so few business owners take the time to ensure that it is adequately protected? Are we too busy? Perhaps you just didn’t know how to protect it, or couldn’t afford the software and hardware required to back up your data correctly.

Ask yourself these questions:

Is there anything more important to my business than my customer data? What would happen to my business if I were to loose all of my data?

Consider this common scenario. A client calls frantic that she’d loose her business if she couldn’t recover her customer data. She had over five years of information on her computer when the hard drive decided to make her life interesting.

If You are running an Online Work at home Business it is very critical that you create a well organized directory structure. The Obvious advantage of an organized Directory structure is it makes it easy to find what you need. A Less Obvious but More Important Reason is it makes it easy to back up your Online Business Files if they are all in the Same Place.

A very Simple Directory Structure for an Online Business Mimics a File Cabinet. You would have 3 Level of Directories. Your Top level would be the File Cabinet, Your 2nd Level would be the File Drawers and your 3rd Level would be your File Folders.

Step 1 (File Cabinet)

Decide where to place your Top Level Online Business Directory. I suggest creating a Directory Directly under My Documents called My Online Business. You may want to think of this Top Level Directory as a File Cabinet with many Drawers

Step 2 (File Drawers)

Decide what are your 2nd Level Directories (The Drawers of your File Cabinet). Here are some of my 2nd Level Directories or Drawers

• My Programs
• My Downloads
• My Income and Expenses
• My Text Ads
• My HTML Ads

Step 3 (File Folders)

With Adware, SpyWare, E-Mail Viruses, Java Script Viruses and Hardware failures It isn’t a matter of If you will loose your Data it is a matter of When you will loose your Data! By spending a few extra minutes now using a Simple Back Up Strategy, you can save yourself big headaches later.

You Should Always have a Full Backup of your Online Business Directory and all it’s subdirectories for the Last 4 Weeks as well daily incremental backups for a month or More. In Addition you should have Monthly off site Backups. I actually Backup my Entire My Documents Directory. My Tools are:

We all know we have to backup regularly, but those backups files can get huge. Add that to your existing your files and your notebook computer hard drive seems to have shrunk overnight. No matter what size hard drive you have on your notebook computer, space is a premium. Besides, it’s not exactly a good idea to store your backups on the same hard drive since you can’t retrieve it — rather defeats the purpose of backing up don’t you think? So what do you do, what are your options?

Backup to an external hard drive. This is probably the quickest, most cost effective option. You can often get a removable drive on sale or with rebate for a low price too. You can get one with hundreds of Gigabytes of space too. They can be easy to hookup to your notebook computer. However, do remember that they are hard drives and hard drives can fail. You may find the external backup fails before your notebook computer does.

Backup on business computers is typically not the user’s concern unless it’s a small business. A business should have a policy in place for managing backups especially due to Sarbanes - Oxyley.

Four options for backing up:

• External hard drive
• CD-RW (CD rewriteable) drive
• Tape
• Network server

Two options for what to back up:

• Everything
• Data files (.doc, .xls, .db, .ppt, .txt, etc.)

Personally, I use an external hard drive (this is a 120 gig hard drive, they also have 20 gig, 40 gig, 60 gig, and 80 gig available. I suggest getting one that is 20 gigs bigger than your hard drive.). It saved me when my computer had to be reformatted a few months ago. Typically, the hard drive is supposed to be rebootable and load everything back exactly as it was before the crash.

Obviously, that didn’t happen. It worked out for the best because some of my system files were bad. The hard drive still had my data files and programs. First, I referred to my latest copy from Belarc Advisor. This is a free program that lists all the applications on your computer. Since I don’t have a CD of every program I use, this was handy.

As someone who has seen quite a few hard drive crashes over the years, I believe that performing a full backup of your computer’s hard drive should be an important part of your weekly (if not daily) routine. There’s nothing more frustrating & costly than trying to restore a computer with only a handful of Floppy disk drives, a couple of scratched CD-ROMs or poorly stored backup tapes.

All too often have I been called upon to try and get a home or office computer working again, only to find that the backup (if any) consists of a few word files and maybe a copy of some accounts data?

Now you might be thinking what’s wrong with that? Aren’t those the important files? Well, yes! But what about your Emails, Address book, all your Desktop/Internet Shortcuts, FTP settings, Anti-Spam & Anti-Popup filters etc.? You’ve spend months if not years getting your PC looking and running just the way you like it and in one split second it’s all gone.

Imagine that you have been working on a file for the entire day and there was a power surge that caused your computer to ‘black out’. It would have been a frustrating experience for us as we had put in a lot of time and effort into it. I am sure that many of us would have experienced data loss in some form or another and have learnt to be wiser to backup our data to avoid any form of data loss.

Have you ever thought of a worst case scenario where a fire broke up and destroy your computer or where your laptop got stolen? Should that happen, the first thing that comes into your mind is the thousands of dollars that you spend on your computer or laptop and you would feel very upset about it. However, when you thought for a second moment, you started to realize that what is really valuable are the amount of data that you have built up over the years in it. Though hardware can always be replaced, even at no cost to you if you have insurance, but lost data is gone forever.

A Tornado? In Birmingham? In The United Kingdom? Unthinkable!

Yes, in July 2005 (while I was putting finishing touches to my cave-house in Spain) my house, along with many of my neighbours’ houses was struck by a powerful tornado that literally tore up the streets. Leaving people homeless as their homes were bulldozered (with all their possessions inside).

Thankfully, my house was still, pretty much intact and won’t be being demolished but I work from a home office. I have lots of critical data and information on my computer - marketing information, accounts information, key contacts, books in progress to name a few. If my house was bulldozered (and I didn’t have an adequate off-site backup system) I would have lost the lot. As it was, I was still able to access my key files even from Spain.

But how would you fare? What if your computer went kaput this very minute? What if a freak accident, theft, or natural disaster literally destroyed your computer and you lost all your files? Would you be able to get back up and running with minimal fuss or would your business be crippled for a long time to come?