multiuser environment: get autonumber value of last inserted record
Posted on 2013-09-24
thanks for all your help all this while just wanna say first = )
got a quick question. i know how to get the autonumber value of the last inserted record - just use dmax.
however if this is a multiuser environment, we may face concurrency issues if other users are also inserting records. how do we get the autonumber of the record we just inserted?
one solution i've thought of is a elookup (or dlookup) and using the WHERE to match fields which make the record unique.
however, if the record has no way of being unique other than autonumber, what is the best way of getting this inserted record's autonumber given that it's a table with high transactions thus concurrency issues?
i instantly think of table level locking but is this the right way? and is there any other way other than table locking?
thanks guys! = )