>I'm running in a multi-user environment on an NT server. Once in a while, I try to use the ID table exclusive and it opens, but I error out when I try to change the field value because the table is Read-only.
>
>Anybody have any ideas on how to force NT to only let one user at a time have access?
I never open a table exclusively except for pack and index. What I will do for my ID table is do an explicit lock on the record first, get the next ID, change the value in the table, THEN unlock the record. This way I do not get duplicate numbers, and I do not create unecessary calls to my error trapping routine for file access denied errors.
Mark McCasland
Midlothian, TX USA