Support Services

    • Dataease to Access Database conversion
    • Access, Dataease, FoxPro Networked Database Design
    • Local or remote problem solving on existing database applications
    • On-site / Remote support service to IT staff
    • The integrated use of Access, Excel, Word, Powerpoint, Sage, Autoroute
    • On-site Training in Database design and Windows products

Microsoft Access Data Recovery

The feeling that you may have lost your data is nearly as bad as the realisation that your backup is not as recent as you would have liked, or worse still, is unreliable.

We will do our utmost to help

You may have seen one of the following error messages indicating a corrupt Access databse file.

Unrecognized Database Format

Enter database password - even though you never previously had to use one.

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

You do not have the necessary permissions to open this object. Please contact your system administrator.

Try the steps listed under Recover Steps before going further.

If this fails then send us your corrupt file and we will provide you with a FREE assessment of the liklihood of recovering your data.

We can recover tables, queries, forms, reports, macros and modules and delete all of your data from our hard drive once we have established that you are back up and running (or have decided not to use our service)

Recovery Questions

Have you tried to Compact and Repair? The answer is probably yes

Is the database Client/Server (a front and back end). If so, are you attempting to repair the right part of the system?

Have you tries creating a blank database, then importing everything from your apparently corrupt copy?

Recovery Steps

This section describes a simple technique that you can use to repair Access databases. It is not 100% effective, but we have had much more success using this method than with the JetComp utility.

First, you should always create a backup copy of your database before performing any type of repair. It is sometimes desirable (and necessary) to return to the original, broken state and try again.

From Windows get to the Control Panel. (Start->Settings->Control Panel).

If you're using Windows XP you need to double-click on the Administrative Tools icon to open the Administrative Tools Screen.

Now look for the ODBC Data Sources icon (in Windows XP it's called Data Sources (ODBC)). It looks something like this:

odbc icon

Find the item that says MS Access 97 Database (or something similar, depending on your version of Access). Shown highlighted here:

odbc screen

Double-click on the MS Access item to display the next screen. Notice the Repair button (we added the green arrow).

odbc screen 2

Click on the Repair button to display a typical file opening window.

odbc screen 3

Once you find your file, double-click on it (or click once and then click the OK button). Hopefully you will now see a simple dialog box telling you that your database has been successfully repaired.

Note that this doesn't mean that your database is now 100% normal, but it is hopefully usable with most of your data intact.

 

Support Services - Help with Windows Software

Your role may be anything other than a software developer, but because of the demands of the job, that is the area that you find yourself getting in to.

We will liase with you on any project to enable you to complete the task.

The areas in which we have found this service to be of use are as follows.

  • Database design in Microsoft Access where you have the basics but need to take things a step further.
  • Database design in FoxPro.
  • Word document content from tables to the inclusion of charts and graphics.
  • Excel Spread sheet problems where you want to use all the "bells and whistles".
  • Making a Power Point presentation look professional and out of the ordinary.

Call us on 01522 788476 8.00 a.m. to 7.00 p.m. (BST), to discuss this service.

Return to Top

 

.