Hi,

I'm trying to extract the autonumber following an INSERT on an Access 2000 
DB. There is the possibility that concurrent connections may be made so I 
cannot use SELECT MAX(ID) FROM .... and I don't want to use the current 
session ID as the a reference to the new record being inserted; (if all 
else fails I may have to).

I know how to do this using ADO, MSSQL, etc. but not with .NET

Does anyone have any ideas?

Cheers

Pear