I know Access and VBA like the back of my hand. I know basic VB code very well too. However, I'm somewhat new to VB6, ADO, COM, and MTS. I was reading a tutorial about ADO and a little work around for retrieving the ID of a newly added field (in Access terms, an AutoNumber).

Basically, the work around said to add the new record, refresh the recordset, move to the last record, and retrieve the ID. Obviously, the theory being that the last record is the most recent one.

Well, here are a few questions that the work around spawned in my head .....

If you have an networked application where multiple people might be adding a record at the same time, how can you be certain that last record after you refresh is the one you just added?

How is that affect with different locking parameters?

How is all that affected if you are using MTS or a just transaction process in general?

I have a very large application written in Access, which I intend to redo (at least a piece at a time) in VB6 with SQL Server 7. I use this function of getting the newly added ID all the time in that app (to update a whole host of related tables).

Any suggestions would be appreciate.

Thanks,

Chad Brake
[email protected]