Multiuser Paradox with cached updates

Greetings from South Africa!

Has anyone got this to work? I require it to work as follows:
User1 updates record, applies updates
User2 updates same record, system should report that record has been
updated by another user.

Thanks in advance,
--
Bruce Swart (br...@cm.co.za)