HLRosenberger
asked on
Access Database, Return Priimary Key of the last inserted record, using OLEDB connection.
How can I get back the Primary Key of the last inserted record, using OLEDB connection.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can also do this:
once you update the record:
AutonumberFieldname is the fieldname of the AutoNumber field
once you update the record:
rs.bookmark=rs.LastModified
myVariable = rs!AutonumberFieldname
WHERE rs = recordset variableAutonumberFieldname is the fieldname of the AutoNumber field
ASKER