strangeryet
Programmer
Hello,
I have a VB App that opens and closes an Access database in different sub procedures.
When the sub procedure that use the ADO method to read the database closes the database the .ldb goes away.
However when I run an Update statement like this in another procedure:
Set dbase2 = CreateObject("access.application")
dbase2.OpenCurrentDatabase "database path"
SQL = "Update Statement"
DoCmd.RunSQL SQL
dbase2.CloseCurrentDatabase
After the update runs the .ldb does not go away.
Is'nt the CloseCurrentDatabase statement all I need to close the connection? The connection does not go away until I end the VB application. ..However...
This app will be set up on a timer and will be open always. So how do i end this connection?
Thanks for you help!
I have a VB App that opens and closes an Access database in different sub procedures.
When the sub procedure that use the ADO method to read the database closes the database the .ldb goes away.
However when I run an Update statement like this in another procedure:
Set dbase2 = CreateObject("access.application")
dbase2.OpenCurrentDatabase "database path"
SQL = "Update Statement"
DoCmd.RunSQL SQL
dbase2.CloseCurrentDatabase
After the update runs the .ldb does not go away.
Is'nt the CloseCurrentDatabase statement all I need to close the connection? The connection does not go away until I end the VB application. ..However...
This app will be set up on a timer and will be open always. So how do i end this connection?
Thanks for you help!