Lynn,
In addition to the other suggestions, I think it was Steve Hartman
and Dennis McGrath that came up with a really slick simple
solution (probably why I forget what they did <g>)... maybe they
will repost or you could email privately.
Ben Petersen
On 10 Jul 2001, at 21:36, Lynn Shelton wrote:
> 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]
>
>
>
