Closing Database Question
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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL