Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting Identity after SQL-"INSERT"

Status
Not open for further replies.
n0nick

n0nick

Programmer
Apr 28, 2005
32
0
0
NO
How can I get AutoNumber that Access made for the new post after a INSERT statement, back to the ASP? Im using ADO objects to connect and get data from Access DB.
 
Sort by date Sort by votes
Retrieve the first field returned by a "SELECT @@Identity" recordset (command text).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
I asked the exact same question a couple of days ago...

thread701-1096165

it worked...

--------------------
Procrastinate Now!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
66
combo
combo
IrishJim
  • Locked
  • Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
60
IrishJim
IrishJim
lameid
  • Locked
  • Question
ADO UpdateBatch SQL Server Example?
Replies
2
Views
91
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Why can't I suppress warnings after Update Query? 3
Replies
14
Views
47
xweyer
xweyer
lameid
  • Locked
  • Helpful tip
DoCmd.OutputTo Error 2501 "The output action is cancelled by the user".
Replies
0
Views
70
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top