Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Columbus, OH
    Posts
    36

    Unanswered: Select @@Identity from Access Wrong

    I have a C# WinForm application with Access as the backend. Per Microsoft I am retrieving the identity column during the OnRowUpdated event. See this link:

    http://msdn.microsoft.com/library/de...mbervalues.asp

    After inserting records it mysteriously returns either 0 or 10. I am thinking that 10 is an error code since I have about 300 records in my table. Please help.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Can you post the code you are using?
    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
  •