
Accessing to a ODBC MSAccess database by rdo at same time
Hi
I have a MSAccess Database Shared by ODBC driver and I'm accessing it
through RDO objects the case is as follows:
when some client access to the DB a field must be marked in order to avoid
to repeat specific process to calculate some value but if two clients send
the request (SQL & OpenResultset) at same time the field can be read with
non marked value and the process is executed twice and the value is double
and wrong.
The question should be: How can I lock the record so it can't be read by two
clients at same time? or, How can I do a stronger validation?
I don't have much experience with this.
Thanks in advance
Enrique Cese?a