Problem with SELECT @@IDENTITY query

[Sameer Motwani]

Hi,
I tried using the query SELECT @@IDENTITY to retrieve the Identity value of
a record after inserting it in a Replicated Access 2000 database but it
always returned 0, the Primary Key field in my table is of type Guid (not
Autoincrement).

Does anyone has any suggestions as to how I can retrieve the Guid ID value
from the Inserted Record

Thank You,
Sameer

 

[Joe Fallon]

As I understand it your app should set the GUID and include it in the Insert
statement.
Then you do not even need to get it back.
That is the big advantage to a GUID - you already know it.

 

[William Ryan]

Sammer:

I'm not sure about GUID columns, but you can use this
http://msdn.microsoft.com/library/d...cpconretrievingidentityorautonumbervalues.asp
to do it with a standard autoincrement field in access. .