hi all i have another question
i have that programme where different users should be able to read data from a database and make changes in those, concerning on what permissions they have.
now if 2 or more users try to change things in a database that could result in some mistakes so i thought i need to do the connection with adLockPessimistic
but then i read that adLockOptimistic might do it too?
does adLockPessimistic mean two persons cant read from a table at the same time? or just not make changes at the same time?
and what if one user opens that special field to read then a second user makes a change? then the first user wont see that meanwhile there has been made some changes unless he closes and reopens it
does somebody know which adLock i would best use here?
Thanks
i have that programme where different users should be able to read data from a database and make changes in those, concerning on what permissions they have.
now if 2 or more users try to change things in a database that could result in some mistakes so i thought i need to do the connection with adLockPessimistic
but then i read that adLockOptimistic might do it too?
does adLockPessimistic mean two persons cant read from a table at the same time? or just not make changes at the same time?
and what if one user opens that special field to read then a second user makes a change? then the first user wont see that meanwhile there has been made some changes unless he closes and reopens it
does somebody know which adLock i would best use here?
Thanks