Connecting Tech Pros Worldwide Forums | Help | Site Map

Next "Available" record ?

me
Guest
 
Posts: n/a
#1: Nov 13 '05
I'm building a multi user app where many admins will be making calls to
people in one table. I want to keep things simple and find a way to prevent
2 or more admins from working on the same record at the same time. In other
words I need a way to go the next "available" record. Any help will be
greatly appreciated, please reply here in the NG. Thanks in advance !!



Ed Robichaud
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Next "Available" record ?


Not sure what you mean by "next available", but Access/Jet takes care of
multi-user clashes by using locking, Look at the Access help explanation
of "record locking". I recommend "edited record" for the best safety vs.
performance setting.
-Ed

"me" <noway@cox.net> wrote in message
news:0zxOd.42915$B95.6183@lakeread02...[color=blue]
> I'm building a multi user app where many admins will be making calls to
> people in one table. I want to keep things simple and find a way to
> prevent
> 2 or more admins from working on the same record at the same time. In
> other
> words I need a way to go the next "available" record. Any help will be
> greatly appreciated, please reply here in the NG. Thanks in advance !!
>
>[/color]


Closed Thread