Retrieve ID after inserting into Access database

Discussion in 'ASP .Net' started by refer_to_website@nospam.com, Oct 28, 2003.

  1. Guest

    I am using VB.NET to insert a record into an Access database. The
    database table uses an AutoNumber for its primary key. How can I
    determine what value Access assigned to the primary key?

    All the research I've done says to use @@IDENTITY but that appears to
    only work for SQL Server? How can I do this in Access?
    , Oct 28, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. wjer
    Replies:
    1
    Views:
    486
    Alvin Bruney [MVP]
    Mar 2, 2004
  2. altergothen
    Replies:
    2
    Views:
    374
    Hans Kesting
    Apr 19, 2004
  3. Arnold Peters
    Replies:
    1
    Views:
    427
    Paul Lutus
    Oct 20, 2004
  4. Replies:
    0
    Views:
    397
  5. geeteshss
    Replies:
    0
    Views:
    416
    geeteshss
    Jun 20, 2007
Loading...

Share This Page