Results 1 to 3 of 3
  1. #1
    HU957 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    1

    ODBC - inport-how many primary keys can i use?

    When I try to inport a record by ODBC and this table have 12 (or more) primary keys, i got an error message, that i can't use more than 10 primary keys.



    Is this officially problem or can i to solve the problem in the setting?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Why do you have so many Primary Keys? That doesn't seem to make sense to me to ever have that many.
    Can you describe/post some of your data (or examples of it)?

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    You don't have 12 primary keys, you have 12 fields that compose a unique key, there's a difference. A primary key is a single field that is not repeated anywhere in your dataset. A unique key is a single field, or combination of fields that prevents you from having duplicates in your data. If you want to make a single primary key you would have to concantenate all your 12 fields into a single field, assuming none of the 12 fields would ever change.

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

Similar Threads

  1. primary and foreign keys?
    By themebuddies in forum Access
    Replies: 1
    Last Post: 12-14-2014, 09:23 PM
  2. Multiple Primary Keys
    By JonathanOz in forum Access
    Replies: 2
    Last Post: 03-22-2013, 08:32 AM
  3. Primary Keys & Relationships
    By Njliven in forum Programming
    Replies: 4
    Last Post: 12-17-2012, 09:42 AM
  4. primary/foreign keys
    By st1300 in forum Database Design
    Replies: 38
    Last Post: 12-04-2011, 01:27 PM
  5. Query using the same primary keys.
    By Franuzz in forum Queries
    Replies: 1
    Last Post: 04-11-2011, 11:27 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