Indsætte Identity

No,as far as I know it isnt in Access. The ID isnt known until the record is created and then its too late.
But why is this necessary, if its the same as the ID then you kno wthe value

Man kan nu godt have brug for det, terry - gæt: int-feltet starter med at pege på samme record, men kan senere ændres til en anden. Så man skal gøre det i to trin

1) INSERT ...
2) UPDATE ...

Yes I am aware but I'm asking why, not saying it isnt necessary

It is an parameter passed to a webpage, and its a erik says something done in two steps. Can you send a string with two sql in seperated by something like ";"? Is that possible, or do you have to do two executes? So you could do something like:
insert ..... update table set id = (subselect something)

If we are talking ASP then you will need two seperate steps, you cant send two SQL statements seperated by ;

and you also need to get hold of the ID just created too.

Ok thanks for the reply. I really miss stored procedures in Access.

thank you too.