Getting ID of last inserted...

[Anon]

...item by me in an Access database where ID is auto incrementing? Is this possible? The problem that I am afraid of running into is where another user might insert an item immediately after my insert statement, thus rendering a selection of the largest ID to be a mute point. Might anyone be able to offer some suggestions/solutions? Thank you.

[daarius]

in mysql you can simply do mysql_insert_id() and that will give you the last id inserted by you.

i dont know what can be done in MS Access... (another reason not to use Access :> )

Daarius...

[Anon]

D'oh! Anyone else?

[Anon]

I don't think there is a simple way out of this.
I mean you will have to requery your DB for the last inserted value

Since You said it was a autoincrement table
why don't you just use
select MAX(id) from table

Id being your table column (Auto increment)

[Anon]

After your insert use this query

select @@identity

[Anon]

I'm sorry I never read your whole problem

I don't think this will help

I am not sure this is fool proof again

But can't you just add a session id in the DB which will help you identify the item till you finish your transaction then nullify the session variable once your transaction is complete.

In this way you don't run into the problem of second user entering his item