Fri, 15 Nov 2002 03:00:00 GMT

Locking Record On Ms Access 97 In MSACCESS (DAO)

I have connected Ms Access 97 by DAO(MSACCESS) and Table is
CacheUpdate. And I want lock record such as connected by
ODBC. for example
   10:00:00   A.M.   User A Click Edit Button to edit data in record# 10.
   10:00:15  A.M.  User B Click Edit Button to edit data in record# 10.  
   10:00:30  A.M. User A Click Post Button to Applyupdates,
                      CommitUpdates.      
   10:00:35  A.M. User B Click Post Button to Applyupdates,
                      CommitUpdates. And Warning Message Record
                      Lock  by Another User.
How Can I do by DAO (MSACCESS) ?  Thank you for suggestion.