Results 1 to 2 of 2
  1. #1
    Naomi Manickam is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    9

    Error when Importing from a .mdb to a .accdb

    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.


  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Later versions of Access are almost always pickier than earlier versions. However, their error reporting is not necessarily more specific. You should create a *new* db in ac2010 and then import the .mdb into it. It that what you did?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Error when importing text file
    By narendrabr in forum Import/Export Data
    Replies: 1
    Last Post: 01-11-2013, 03:27 AM
  2. Importing objects error
    By Abacus1234 in forum Import/Export Data
    Replies: 8
    Last Post: 06-15-2012, 10:31 AM
  3. Error Importing Specifications
    By x0200196 in forum Access
    Replies: 3
    Last Post: 06-08-2011, 09:09 AM
  4. Undefined error importing spreadsheet
    By kbremner in forum Import/Export Data
    Replies: 1
    Last Post: 10-23-2010, 05:57 PM
  5. Error message when importing
    By ljenkins23 in forum Access
    Replies: 5
    Last Post: 06-10-2010, 09:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums