key of inserted record (autonumber)

A

Alan Morris

I am using a detailsview to insert records into an accessdatasource.

I just want to retrieve the primary key of the inserted record.

I have seen all sorts of solutions for an objectdatasource or an
sqldatasource, but cannot find a solution for accessdatasoure.

I have tried using select scope_identity() at the end of the INSERT
command.

It can't be that difficult can it?

Help please!!!
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,899
Latest member
RodneyMcAu

Latest Threads

Top