>Can you use this SQL "SELECT GETAUTOINCVALUE(0) FROM OneRecordCursor" ?
You cannot use a cursor in OleDB. Also, such a command would need to be executed at the same time the insert is done, which I don't think is possible under this environment. What I do for now is to select the last record added to the table from that user. For any new record in a table, I have a field AddUser which is maintained. So, I select the last one and this gives me the record ID. But, I don't like this approach. I really something at the insert level.