Be sure to specify the keyword for the object (database, table, view, or rowhash) that is to be locked.
For example, if a database and table are both named accntrec, then you could specify the following form:
LOCKING TABLE accntrec FOR ACCESS SELECT * FROM accntrec;
If the TABLE keyword had not been included, the lock would have been placed on the accntrec database.