Link to home
Start Free TrialLog in
Avatar of Ddan
Ddan

asked on

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?
Thanks
Avatar of web_crusher
web_crusher

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!
ASKER CERTIFIED SOLUTION
Avatar of dabellei
dabellei

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial