"jeffhg582003" <[EMAIL PROTECTED]> wrote: > >I am developing a python script which add records to >a microsoft access tables. All my tables have autogenerated number >fields. I am trying to capture the number generated from the insert but >I am not exactly sure how to do that after an insert.
http://support.microsoft.com/kb/221931/EN-US/ What tool are you using? With ADODB recordsets, you can fetch the "absolutePosition" property, save it, do a Requery to update the recordset, then set absolutePosition to the value you saved. Now, you can read the fields of your new record, including the autonumber. -- - Tim Roberts, [EMAIL PROTECTED] Providenza & Boekelheide, Inc. -- http://mail.python.org/mailman/listinfo/python-list
