Re: @@IDENTITY for Access -- Is it thread safe?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tim Ferguson <FergusonTG@xxxxxxxxxxxx>
Date: Wed, 05 Oct 2005 09:34:09 -0700

"Siegfried Heintze" <siegfried@xxxxxxxxxxx> wrote in
news:#SaNk7byFHA.460@xxxxxxxxxxxxxxxxxxxx:

> Is @@IDENTITY thread safe in that it returns the autoincrement value
> for the most recent insert for that thread or just the most recent
> insert by any thread?

Help file says it's per connection. I don't think database servers know
anything about threads.

Tim F

.

Prev by Date: Re: MDE greyed out on menu
Next by Date: Populate one table from another
Previous by thread: Re: MDE greyed out on menu
Next by thread: Re: @@IDENTITY for Access -- Is it thread safe?
Index(es):
- Date
- Thread

Relevant Pages

Re: Unique Time Stamp
... I thought about combining the timestamp with an ... autoincrement number but can't seem to get the end result desired. ... you can give me a simple example I would be very grateful. ... Prev by Date: ...
(microsoft.public.access.formscoding)
DataTable.DefaultView.Find doesnt
... After creating a NewRow and Adding it to a DataTable, ... autoincrement ID of -1. ... Terry ... Prev by Date: ...
(microsoft.public.dotnet.framework.adonet)