Inserting record with Microsoft Access

[Tim Roberts]

"jeffhg582003" <jeffhg582003 at yahoo.com> 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, timr at probo.com
  Providenza & Boekelheide, Inc.