Insert a record and retrieve the unique ID

[Belfast75]

Hi,

I am inserting a record into a table to hold information about photos and what to create a folder with the same name as the primary key value of the inserted record.

Eg if I have a table (tblAlbum) with two fields (albumID, albumName) and run an insert statement 'INSERT INTO tblAlbum (albumName) VALUES ('test album')`

I want to then create a folder with the new value for albumID.

How do I retrieve this new value just created?

Many thanks,
Des

[bbolte]

here's a couple of examples:
http://aspin.com/func/search?tree=as...at=all&x=0&y=0
http://www.kamath.com/tutorials/tut007_identity.asp

[r937]

bill, both those articles recommend @@IDENTITY

however, best practice is to use SCOPE_IDENTITY instead

[bbolte]

best practice is to use SCOPE_IDENTITY instead

i'll have to look that up then, thanks for the heads up...

[bbolte]

it doesn't look like scope_identity works with Access though and for some reason think that's probably what is being used here...

[Belfast75]

Many thanks for the help, I'll be looking at this over the weekend.