If you are getting locked records, I would run the following script in query analyzer. This will tell you which records Macola is locking and which user is using that record.
====================================
--Sets the database to the locking database
use msllockdb
--show's the user(session id), table and row (ie: order no, item no)
--you can also add dbname if you have multiple companies
select sessionid, tablename, rowid
from maclocks
go
--system command to show all users attached to SQL by spid (sessionid) and what login
--name is using that spid. First, have that user log out of the screen that most likely has
--the row open that is locked.
sp_who
=====================================
Kevin Scheeler