[AccessD] New ID/Autonumber value

On 10 May 2003 at 7:24, Haslett, Andrew wrote:


> Stuart, I am 99% certain that @@Idenity operates on that particulart
> instance of a connection and that you will never get the autonumber
> from another users' INSERT.  I'm happy for you to proove me wrong
> though!!  In fact, it wouldn't be to hard to test, simply need to step
> through the code just before executing the @@Identity statement and
> inserting a record manually into the table, then seeing what
> @@IDentity returns.  Might go test it myself!!
> 

That's essentially what I said  in my last post :-)

>> If you are using an Acces BE with Jet 4 and only updating one 
>> table with the connection, it's safe 


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.