I defined a table with a primary key as AutoNumber.
Now I insert a row - is there a way to know the primary key value that
will be created without locking the table before insert?

Thanks,

Zalek

Perhaps you could explain better what you are trying to accomplish.
Programatically your primary key field is accessable - if you are
using vba you can use MoveLast on your recordset and get the value for
your primary key field by fieldname,

iKey = User_ID
iKey = iKey + 1

or whatever.

John
jobrien at acscience dot com

Zalek Bloom <ZalekBloom (AT) hotmail (DOT) com> wrote