Fix Microsoft Office Access 2010: Web Compatibility Checker Errors

About Microsoft Office Access 2010: Web Compatibility Checker

In MS Access 2010 there is cool feature like Web Compatibility Checker that lets you check your database for web compatibility issues. This feature is really very helpful if you want to migrate existing application to the web.

Steps To Run The Web Compatibility Checker

It is quite simple to run the web compatibility checker.

  • Just lunch the MS Access 2010, and open the database for which you are willing to apply the compatibility checker.  Hit the Office button and head over the Share option.Web Compatibility Checker-1
  • Now click the Publish To Access Services option in the left sidebar and then locate the Check Web Compatibility button on the right sidebar.

Web Compatibility Checker-2

  • Click that button and your database will be checked for any compatibility issues.

 

Web Compatibility Checker-3

  • If any compatibility issue caught in the database then click the Web Compatibility Issues button to check out the list of issues.

7 Most Common Access 2010 Web Compatibility Check Errors Along With The Fixes

While you run the Web Compatibility Checker Tool, a table is created to list any errors encountered. In this topic, we will discuss about how to deal with the Access 2010 Web Compatibility Issues, and also give the best suited fixes to troubleshoot those compatibility errors.

Web Compatibility Check General Errors

In the image error listed indicates that a column in table  2 has a data type that is compatible with the web.

Error #1  ACCWeb102001

Error text: Property value contains more characters that are incompatible with the web.

Meaning:   invalid use of object name or the control name on the web.

Resolution: Make sure that the object name doesn’t violate any of the rules:

If the characters that are contained in property value that are not compatible with the Web.
Say for example table, field, as well as control names should not contain any characters which are not accepted by Access client.

 The entire length of characters should not exceed 64 characters and should not contain any of the following symbols: # <TAB> { } % ~ / \ : * ? “” < > | & period (.), square brackets ([]), exclamation point (!), leading space, or beginning with an equal sign (=).

Further Reading:

Fix MS Access Error – SQL Server Does Not Exist Or Access Denied

Error #2 ACCWeb102004

Error text: Property value must be the default value to be compatible with the Web.

Meaning: in the web databases only the default value of the indicated property is supported.

Resolution: replace the current value of the property with the default value of the property.

Error #3 ACCWeb102011

Error text    Property value must be value to be compatible with the Web.

Meaning: It means that the indicated property must have the indicated value in a web database.

Solution: Replace the property value to the indicated value.

Error #4 ACCWeb102002

Error text:   Object name depends on object name which does not exist.

Meaning: Indicated web object relies on another object that is not web object.

Resolution: Remove the reference to the client object. Recreate the client object as the web object and replace the reference to the client object with a reference to the new web object.

Error #5 ACCWeb102013

Error text    Property value must not be blank to be compatible with the Web.

Meaning: Indicated property must have a value to work in a web database.

Resolution: Give some value to the property.

Error #6 ACCWeb102000

Error text :   Object name depends on client object object name.

Meaning: The indicated web object depends on another object which is not a web object

Resolution: Remove the reference to the client object. You may also need to recreate the client object as web object and replace the reference to the client object with a reference to the new web object.

Also Read:

Top Fixes To Repair MS Access 3343 “Unrecognized Database Format “ Error !

Error #7 ACCWeb102008

Error text:   Object name depends on object name which is incompatible with the Web.

Meaning: First object will reference the second object but the second object is not present on the web.

Resolution:  Remove the reference of the second object or else replace the reference with other object’s reference that is web compatible.

There are many more errors related to compatibility, One can get rid of all those errors with the help of professional recommended Access Repair & Recovery Tool.

About MS Access Database Repair Software

Access Repair & Recovery Tool is software that is particularly designed to repair corrupt or damaged MS Access database files. It comes with powerful algorithm that scans even severely corrupted access database files. It also has highly interactive GUI that helps user to easily operate and repair Access database without making changes in the original structure of the file. It easily restores damage or corrupt tables, queries, indexes and other data.

This tool can easily fix all minor and major database errors and problems of MS Access 2013, 2010, 2007, 2003, 2002, 2000 on almost all version of Windows operating system such as Windows 8/7/Vista/XP/2003. Free trial version is available that you can install to check the features and reliability of the software.

Steps to Recover Corrupted or Damaged MS Access Database

Step 1 – Download and install the Access Repair & Recovery software. After installing, select the corrupt Access file for repairing by clicking on “Select file”.

1

Step 2: This software will give you the list of all searched file in a drive. Select the file you want to repair and click on “Repair” button.

2

Step 3: The repairing process will start as you see in the image below and you can see the log report for detailed analysis.

3

Step 4: Once the repairing process completes, click on “OK” button to see the preview of the database objects.

4

Step 5: You can now see the preview of the repaired file.

5

Step 6: The tool will save repaired database by default to the location where the corrupted database was saved but it will rename the file. However, you can select your own desired location to save repaired database.

6

Step 7: Once you select the desired location you can then see that saving is under process.

7

Step 8: Finally, saving completed.

8

7 Ways Fix Microsoft Office Access 2010: Web Compatibility Checker Errors