Closing Access97 Tables

When you exit a complied VB5 app does VB automatically close the DB and all of its open tables and recordsets? It is my understanding that everything is closed and cleaned-up automatically. If this is not true what is the safest method to close an app that uses several Access97 databases?
Who is Participating?
dabelleiConnect With a Mentor Commented:
Exiting the application close all database.  But it is always a good idea to close database before exiting a program.

dim db as database
set db = opendatabase("....")


Don'T forget you have to close all object before closing the database, like recordset.

Hope this help
Vb5 do closes all db at the end but you never know where
the next microsoft bug will occur - i always close my db with several metodes like : data1.Recordset.Close
and data1.refresh

try looking in recordset help - there are several ways - and they all good for multi database operations

Do not Plan on depending on other application to close your db
remmember - a db is very important to a program and system
handle it yourself !!
after rejection a comment of yours should be added!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.