Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Posts
    2

    Unanswered: Cannot edit a SQL table without primary key in Access 2002 adp datesheets? Why?

    Tried to edit the SQL 2000 Tables from the Access 2002 ADP, i was able to edit a table with Primary key but wasnt able to edit a table without.
    Why should i force my database design to have one, i know that i would be a better design but my design does'nt needs a pKey.

    Justin Benedict.

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: Cannot edit a SQL table without primary key in Access 2002 adp datesheets? Why?

    Do you mean edit the data in the table? If that is the case, this is due to the fact that SQL needs to uniquly define each record before doing an editing.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The only designs that don't need a primary key are bad designs. Add one.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •