>what's in your Keys table? nextid and ...? and are any of them primarys?
Actually I have no "keys" table anymore :) When there was I only used TableName and NextId. None primary (since no RI there I don't need a primary). It can even be a free table. Only thing is that it's used unbuffered.
Currently I use character generated PK (bintoc(logonrecno)+sys(2015) - each user lock a record for the entire session in logon table, no problem s/he might have a hangup because recs are logon point specific with data such as netbios id, TCP/IP etc). Downside I spare up to 13 chars for a PK (don't care diskspace as I do in old days :)
Cetin