We are using ado to connect databases over the internet

We have a problem with defining new key's using ado

Normally we have an extra databases with the latest en highest
keys per table.

If we create a new key we lock the record and create a new keynumber

What is the best way to do this with ado example please.

Kind regards


Jan Dorresteijn