Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to lock a record and say the user cannot change this.
Hi!
I have a problem:
* Many users of the same form = No problem.
* Users using different records in the form = No problem
* Users trying to change the same field of the same record = Problems.
Especially in comboboxes which RowsourceType is a table
Results: the last user is expulsed of the form with this message:
"Cannot access the selected table"
Set Exclusive is off
What to manage this problem?
I would like to lock the record used by the first user, and say the last user who wish to change the record: "Record is in use by another one..."... but don´t know how exactly lock just the record...and when (and where -event-)to send the message.
Can Anyone help me?.
Thanks in advance.
Carlos Burgos
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement