Record Locks in MS SQL 7.0

    I have an application written in Delphi 5 using the BDE native drivers
for SQL.  I am having a problem with record/page locks on some of my tables.
I do not get any deadlock messages, just lock timeout errors.

    I look in the enterprise manager and there are locks on some of the
tables in the database.  I kill the process that is tied to the lock and the
system starts to run correctly again.

Can anybody show me where to look as to where the locks are coming from and
how to prevent them.

Thank you in advance for any help.