By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,423 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,423 IT Pros & Developers. It's quick & easy.

Next "Available" record ?

P: n/a
me
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 !!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <no***@cox.net> wrote in message
news:0zxOd.42915$B95.6183@lakeread02...
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 !!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.