Access Help for the I/O Access Method you are using is a simple source. For
example, putting your cursor in the word OpenRecordset and pressing F1 in
either Access 2002 or 2003 will take you to the Help on the OpenRecordset
method, which will explain each of the arguments used in the OpenRecordset
method:

Set recordset = object.OpenRecordset (source, type, options, lockedits)

scrolling down will take you to the various built-in constants that may be
used in the lockedits argument.

Open a Form in design view. If the Property Sheet isn't open, right-click
the upper-leftmost little box and choose "Properties". Click the Data tab of
the Property Sheet, and you'll see one of the Properties on that page is
"Record Locks".

Include appropriate error handling code in the VBA module or the Form's
module.

In either case, choose the least restrictive level of locking. Use that
while you develop and test. When you subject your application to heavy user
testing, if you find that you have "collisions" very often, you may have to
increase the locking level to a more restrictive one.

I haven't had to do so, but I have not developed many heavily-used multiuser
applications; most of my work has been with either single-user databases, or
with Access clients to server databases, so you can't take it as a good
indicator of what level of locking you will end up using.

 Larry Linson
 Microsoft Access MVP