I have a question concerning the closing of a database. I'm maintaining an
app written in VB6 and Access 97. The same database is openned in several
procedures using the OpenDatabase method, but I don't see where it's closed
in any of the procedures.

My question is, does an open database get closed automatically when exiting
a procedure? The reason I ask is that in one of the app's procedures a table
in the database is looped through to change a field's value in all records.
During this loop i'm getting a record locking error, even though i'm the
only user, so my suspicion is that i'm somehow locking myself out.

If anyone knows the answer to my question or can shed some insight into my
record locking problem i would definetely appreciate it.

Kevin McGuire