Due to some programming constraints, I have to do my own autonumbering field
management - i.e. not using the standard autonumbered column method. I can
do this with no problem on a stand-alone application, but I am concerned
with potential problems if the application is adapted to operate on a
network in multi-user mode.
I remember a couple of years ago a pretty good discussion on methods for
doing one's own autonumber routine that avoids duplicate numbers being
assigned in a multi-user situation. I had this discussion printed out at
one time, but have lost it. Can some of you give me some refresher
hints/tips? I have to have this application ready for demonstration in the
next couple of days, so I will do my stand-alone (single-user) method for
now, and hopefully modify the code later for conflict-avoidance in
multi-user mode.
TIA
Lynn Shelton
[EMAIL PROTECTED]
