Key violation in Access tables

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ahmadbaseet
    New Member
    • Aug 2007
    • 15

    Key violation in Access tables

    Hello every one. In Access database, I have two tables which are connected by One-to-Many relationship. like:. 1 is Projects, 2 is subprojects. I am tryin to enter the data bay sql statement, But i am getting the Key voilation Error. Can anybody tell me what could be the problem. Thanx
  • JKing
    Recognized Expert Top Contributor
    • Jun 2007
    • 1206

    #2
    Are trying to insert autonumbers?

    Comment

    • ahmadbaseet
      New Member
      • Aug 2007
      • 15

      #3
      No I am not entring Auto numbers field

      Comment

      • JKing
        Recognized Expert Top Contributor
        • Jun 2007
        • 1206

        #4
        Could you post the code you're using and could you please include the MetaData for all relevant datasets? Here is an example of how to post table MetaData :

        Table Name=tblStudent
        Code:
        [i]Field; Type; IndexInfo[/i]
        StudentID; AutoNumber; PK
        Family; String; FK
        Name; String
        University; String; FK
        Mark; Numeric
        LastAttendance; Date/Time

        Comment

        Working...