A1VBCode Forums / Classic Visual Basic (VB 6 or earlier) / Database Programming / Access Database error 3709 heeeeeeeelp / Latest Posts

RE: Access Database error 3709 heeeeeeeelp

James_1100 — Thu, 07 Apr 2005 21:31:06 GMT

No need to close the db once the form is close. Just close the db every after query. e.g.

rs.open "Select * from Db"
'Code Here

rs.close

But dont forget to close the connection once the form is close e.g.

Private Sub cmd_Exit()
cnn.close
End Sub

Hope this helps..

regards,
james

RE: Access Database error 3709 heeeeeeeelp

Sco2004 — Wed, 06 Apr 2005 08:31:14 GMT

thank you very much

I want to ask you.

Should I must to close connection to My Database after closing every form (if I oprn database in this form) or not and if i Wrote rec.close

rec.close

set rec=nothing is enough to close connection to my database or not

And what is best way to close connection to database

bacause my program is still present in memory after closing the program

Thank you very much

Sorry for my bad English

RE: Access Database error 3709 heeeeeeeelp

James_1100 — Tue, 29 Mar 2005 00:10:24 GMT

Good thing i help

regards,

RE: Access Database error 3709 heeeeeeeelp

Chippy — Thu, 17 Mar 2005 23:21:12 GMT

That Helps
Many Thanks
: Chippy

RE: Access Database error 3709 heeeeeeeelp

James_1100 — Wed, 16 Mar 2005 21:34:01 GMT

Hai..

once you close the connection, you cannot open the database that's why you got error. You can do it this way after the query:

rs.Close
Set rs = Nothing

Hope this helps..

regards

Access Database error 3709 heeeeeeeelp

Chippy — Fri, 11 Mar 2005 11:27:33 GMT

Hi all

I have an application with a data environment on that has a connection object with a load of commands which all works fine ,

However I want to close the connection in order to make a backup of the access database which I can do,
but the problem is that when I reopen the connection and try and access data thru 1 off the command objects I get the 3709 error Operation not allowed on an object referencing a closed or invalid connection,

we have tried checking the connection state so we can take the appropriate acction depending on it's state but no good we have also tried changing the connection string but this doe's not seem to have any effect either, so at the moment we are up a gum tree

anybody any Ideas ?

any help would be welcome thanks

Chippy