Record restrictions in forms

[Lyndon]

Hi All,
I am currently developing a database where I will have
approx 10 users accessing the data simultaneously. I am
wanting to set this up to prevent multiple users from
viewing a record simultaneously in a form. Can this be
done by hiding the record if a user is currently viewing
it or by causing subsequent users to automatically skip
over it to the next record?

Would greatly appriciate anyones help and thoughts.

Thanks in anticipation of your response.

Lyndon

 

[Jack MacDonald]

to the best of my knowledge this cannot be done at the database engine
level. Instead it must be programmed into your application. When a
user opens a record, your application would store a token in a table.
Other users would check for the presence of that token, and take
appropriate action. The original user would delete the token when it
moved off the record. Might be tricky to program...

Hi All,
I am currently developing a database where I will have
approx 10 users accessing the data simultaneously. I am
wanting to set this up to prevent multiple users from
viewing a record simultaneously in a form. Can this be
done by hiding the record if a user is currently viewing
it or by causing subsequent users to automatically skip
over it to the next record?

Would greatly appriciate anyones help and thoughts.

Thanks in anticipation of your response.

Lyndon

=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd

 

[Lyndon]

Thanks for your response Jack.

It has put me on the right path.

Cheers

Lyndon