Consider the following scenario:
- You publish a Microsoft Access 2010 Web database to the Access Services on a Microsoft SharePoint 2010 site.
- You try to import a table from an ODBC database into a table in the Web database.
When you click Web Compatibility Issues, the Web Compatibility Issues table in the Web database opens. The table contains the following error:
Web compatibility errors were found during import. The import was not completed. For a list of issues encountered during import, click the following link: Web Compatibility Issues.
However, the ODBC table can be imported into an Access 2010 database on a client computer, even though the ODBC table has a Primary Key field that contains a numeric data type.
A Table should have a Primary Key and it should be a number with field size 'long' to be compatible with the Web.
This issue occurs because of a known problem when you try to import an ODBC table into an Access 2010 Web database. When Access 2010 imports an ODBC table, the Primary Key index is not imported. In this situation, only the data in the Primary Key field is imported.
To work around this issue, follow these steps:
- Start Access 2010.
- Create a new database.
- Import the ODBC table into this database.
- Open the table in the Design view.
- Set the ID field in the Data type column to Number
- On the General tab of the Field properties column, set Field size to Long Integer.
- Set the ID field as the primary key.
- Open the Access Web database on the SharePoint 2010 site.
- On the External Data tab, click Access.
- Use the Import wizard to import the table from the Access client into the Access Web database.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.