Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: Access equivalent to @@identity???

    I am trying to get the id of the record that was just inserted into the table. Unfortunately, I have to use Microsoft Access and @@identity will not work. Is there some other command that performs the same operation? I am hesitant to use MAX().
    Your comments are greatly appreciated.

  2. #2
    Join Date
    Feb 2004
    Sorry, I didn't see a forum for Microsoft Access. Maybe this topic should be moved to "Other"??

  3. #3
    Join Date
    Jun 2003
    1,032 : ASP FAQS : Databases, General
    How do I get the record number of a just added record, using an Access database table? by Bill Wilkinson - 11/3/2000

    ADO FAQ - Q9) How do I get the AutoNumber (or Identity) for a newly inserted record?

    INFO: Identity and Auto-Increment Fields in ADO 2.1 and Beyond

    INFO: Identity (AutoIncrement) Columns in ADO or RDS

    User Tips: Getting the ID of the Just Inserted Database Record by Dan H. - 12/26/2000
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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