I do this:

SELECT a Set of records from database
compare this with another Set
If they are the same I UPDATE, INSERT & DELETE to the database

But I need to do these tasks with a locked table or series of records, to
ensure no concurrent writes incur conflict.

How can I achieve this in Access through JDBC-ODBC?

I have read that I must get Access to do the locks rather than JDBC, but how
do I instruct Access to do this?

Or any other suggestions to achieve this goal?