How to Lock Records with ODBC Access 2000 Driver ???
Database
1
Posts
1
Posters
9
Views
1
Watching
-
Hi there all, Well i'm trying to figure out a way to lock a record while working with an .mdb file (Access 2000). When i try to set CRecordset::SetLockingMode(CRecordset::pessimistic) the system will throw an error saying "not supported locking mode" - IS THIS AN ODBC DRIVER PROBLEM OR ACCESS DB ? So ... I tried to find a way to know if there is a way to find when is the record editted (from outside the program since 2 processes are running at the same time) and couldn't - Does somone have an idea of how to FIND OUT IF A RECORD IS EDITTED BY ANOTHE APP. ? Thanks alot for the help i would apritiate it alot, Ariel.