|
Home > Archive > MS Access Multiuser > September 2005 > access.lockrecords
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
access.lockrecords
|
|
| RNWSupport 2005-09-23, 8:25 pm |
| I have a form I want to be available to many users at once. However, I would
like to lock each individual record from being viewed by others, while a user
has it open. Is this possible?
This is a single-user database on a shared folder. Since users will make
phone calls to clients per each record on the form, I don't want them all
making calls to the same client at the same time. Thus, it's not sufficient
to just lock the record for editing. Thanks for any help you can offer.
| |
| Alex Dybenko 2005-09-24, 1:23 pm |
| Hi,
you can lock edited record, using RecordLocks property, but not sure about
viewed.
I think I would try to build a separate table, where I just save what record
each user have opened, and use it instead
--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"RNWSupport" < RNWSupport@discussio
ns.microsoft.com> wrote in message
news:47E32159-8AAF-4085-BF96- 1A0C19DD1C0E@microso
ft.com...
>I have a form I want to be available to many users at once. However, I
>would
> like to lock each individual record from being viewed by others, while a
> user
> has it open. Is this possible?
>
> This is a single-user database on a shared folder. Since users will make
> phone calls to clients per each record on the form, I don't want them all
> making calls to the same client at the same time. Thus, it's not
> sufficient
> to just lock the record for editing. Thanks for any help you can offer.
>
|
|
|
|
|