Results 1 to 3 of 3
  1. #1
    Sara_IT is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Location
    Kingdom of Bahrain
    Posts
    2

    Question Primary key

    Hello everyone...

    how r u? this is my first time in this site =D



    ma qution is y whene i want to save ma tables it say that index or primary key cannot contain a null value!! but primry key feild its does contain value?? y?? so wts the problm??

    thanx alot i am wting 4 ur answers.
    bye bye

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,913
    Only explanation is that there is a record(s) that has a null value in the primary key field. An Autonumber primary key will not error. Remove the Primary key designation then save and open the table. Check that all records have a value in that column. When they do, set the field back to Primary.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Sara_IT is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Location
    Kingdom of Bahrain
    Posts
    2
    aha OK its work thanx alot Jane7 4 yr help

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

Similar Threads

  1. Primary Key
    By DukeBlue in forum Access
    Replies: 18
    Last Post: 09-23-2011, 05:23 PM
  2. Primary key issues
    By NEHicks in forum Access
    Replies: 7
    Last Post: 06-06-2011, 11:19 AM
  3. Primary Key Problems
    By skg in forum Database Design
    Replies: 5
    Last Post: 01-26-2011, 12:42 PM
  4. Primary Key Help
    By phoenix13 in forum Access
    Replies: 4
    Last Post: 07-30-2009, 12:36 PM
  5. about the primary key!
    By Yuesko in forum Access
    Replies: 1
    Last Post: 05-29-2009, 04:20 PM

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