Have an Access db created with Access 2003. Was not updated with Access 2007, and now need to work with it in Access 2010.
Saved the Access 2003 db, a *.mdb file as a *.accdb and imported the data from the *.mdb db.
The import failed and the error report and in the report the Issue Type Error and the Issue Type ID is ACCWeb107014. When I checked this error, the follow explanation was given. However, the tables have a PK. I am confused
ACCWeb107014
Error text A Table should have a Primary Key and it should be a number with field size 'long' to be compatible with the Web.
What it means The indicated table has one of the following problems:
- The table does not have a primary key.
- The data type of the primary key is not Number.
- The primary key Field Size is not Long.