Access 2010 Web Databases: Other Compatibility Errors

Published by Jacob Martin on May 9, 2015

To convert an existing Access application to a web application that can put your Access Database project that starts with the data.

 When you attempt to upload the existing tables into SharePoint and may encounter errors while uploading the data to SharePoint. The error creates the relationships in the web application that creates the relationships.

Here is the discussion for moving the legacy tables from Access to SharePoint here are some of the common errors that keep your tables from uploading to SharePoint.

Other Compatibility Errors

1. The property value contains one or more characters which are incompatible with the web: the table field and control names cannot contains characters which Access client accepts. This is not longer than 64 characters and may not contain any of the following: / : * ? “” < > | # { } % ~ & period (.), exclamation point (!), square brackets ([]), leading space, or begin with an equal sign (=).
2. Allow Zero Length property and Required property need to set ‘true’ to be compatible with the Web: You can set both the Allow Zero Length and Required property of a field to “yes”.
3. The Property value need to be empty or set it to “auto” to be compatible with the web: The error refers to subdatasheets that allows in SharePoint lists. To correct it you need to set the Subdatasheet Name property of the table to [None] or [Auto]. You will come across this message if values in the Link Child Fields and Link Master Fields properties. These properties need to be empty.
4. The Calculated Column expression that can input field of a type incompatible with the Web, such as Memo, AutoNumber, Lookup, Hyperlink or Binary. Calculate columns a new in Access 2010 that won’t be legacy system. However if you use them you need to use the following data types: Text, Number, Currency, Yes/No, Date/Time.
5. The calculated column result data type is incompatible with the Web: the result of the calculated columns can only be of the following data types: Text, Number, Currency, Yes/No, Date/Time.
6. The columns data type for the value list lookups must be ‘Text’ to be compatible with web: if you make use of the Value List for a lookup field that has filled with Text values. You cannot use the numbers. The better solution, however is to create the reference lists that you can query to fill the list.

This Web Compatibility Issues table created by the Compatibility Check will be referencing the errors. In this course, there are errors, many of them associated with uploading your application (forms, reports, etc.) to the web.

To eliminate this type of errors from your Access 2010 you need to make use of the MS Access File Repair Tool. It is the best software that completely repairs all the Access database errors and recovers all the objects including tables, forms, reports, and more. The non-destructive Access Repair software securely repairs of all Access database files after errors or corruption scenarios.

steps to repair

Step 1:Download and install Stellar Phoenix Access recovery software.

Step 2: Just click on “Open MS access file” button on the toolbar. You will find a pop-up window from where you can search or select for an ‘.mdb’/’.accdb’ file in your PC.

Step 3: Look at the image below you will find same image in your computer screen. With the help of this “Customers” table you will be able to view both the data and column information.

Step 4:Preview the column information of “Employees” table.

Step 5: Now you will the preview of database query.

405 Total Views 2 Views Today