Java Database Connectivity (JDBC)

Hi,

I am writing a distributed application (not web based) that uses a single database. The database is MS Access XP (and could be 2000).

The question that I have is how do I lock the database? The need for locking the database araises several times, especially when one user updates a row, while another user could possibly be updating that same row as well.

Also, what are some issues that I should be aware of when using database locking? I can imagine a situation when one user has some information pulled from the database and displayed in some form while another user edits this information in the database. Now, the first user might now want to change the information, but at this point he doesn't have the latest information anymore. I am not really sure how to handle this situation. I mean, I can't really lock the database for the entire time one user thinks about the changes he wants to make...

Any ideas?

Thanks,
Yaakov.