@@Identity In Microsoft Access

[rkatt]

How do you use @@Identity in Microsoft Access??

It doesn't seem to be working for me.

First I execute this:
_______________________

INSERT INTO table (field1, field2)
VALUES ('value1', 'value2')
_______________________

Then this:
_______________________

SELECT @@IDENTITY
_______________________

but the second SQL always returns 0 (zero), even though their primary keys (identities) are not

How do you use @@IDENTITY with Access????

 

[r937]

you will have a much better chance of getting an answer to this question in one of the microsoft access forums

r937.com | rudy.ca