returnér id på indsat post fra php.

with difficulty!

terry -> Hmmm..  If nobody else answers, I\'ll have to give your answer a try :-)

Hvis din Access + driver er passende ny, findes vel @@IDENTITY li\'som på
SQL-server.

Jamen, det er jo fantastisk. 1000 tak.

ericjacobsen -> Jeg troede du havde stoppet din færden her på eksperten.  Svar lige.

Jeg holder lige en lille pause i min pause. Men ok, jeg er åbenbart
mere genial end jeg selv troede.

Hi runesoft>erikjacobsen\'s @@IDENTITY will work with Access 2000 + XP (2002) but you MUST make sure that its the first that you do after INSERTING or you may risk geting the wrong value.

I cant find much information on this subject in ACCESS so I am not sure of the scope, so in a multi user environment it may be a little risky.

No, terry, it works like (ok ok ok, it SHOULD work like) this: The @@IDENTITY dingy
is associated with the current connection. So don\'t close the connection, and don\'t
do anything before reading it. Since multiple users don\'t share connections, it\'ll work
just fine. Don\'t try this in an environment with treads sharing the connection, and
don\'t try it just after your Christmas dinner.

threads, even

I can\'t find information on the access thing either, but the whole purpose of the @@IDENTITY is lost if it was not in connection scope.

Thanks everybody.

Yes I would also have thought that the scope was on the connection, and if it is and not too much Christamas dinner, then all should work fine :o)

Silly that Microsoft done tell us this!

Oh! and thanks for the points.

I pray and hope Microsoft implemented it in a sensible way.