Inserting record with Microsoft Access

[jeffhg582003]

Hi,

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.

Thanks,
Jeff

 

[daftspaniel]

I can't remember the detail right now but look at SELECT @@IDENTITY.

Cheers,
Davy M

 

[Kelly]

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.

Other folks have pointed you to "select @@identity" but I thought I
should mention that if you use ADO with the AddNew method then
autonumbers are magically retrieved. Something like this should work:

rs.AddNew()
rs.Fields("somefield").Value= "Blah"
rs.Update()
print "Autonumber is", rs.Fields("TheAutonumberField").Value

This didn't always work so ADO and the MDB can't be ancient versions.

SQL Server will also do this but the recordset must be opened with:

rs.CursorLocation= constants.adUseServer
rs.Open("Tablename", conn, constants.adOpenKeyset,
constants.adLockOptimistic)

 

[Tim Roberts]

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.