Connection error 3709 - why does this happen?

D

Debbie

Hello,
I occasionally get the error :
RunTime error 3709: Connection cannot be used to perform this operation. It
is either closed or invalid in this context.

My connection procedure looks like this:
OConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\Owner\My
Documents\DTS\DPD\ClientDB\ClientDB.mdb;" & _
"User Id=admin;Password="

Every time I open a connection, I close it and set it equal to 'Nothing'. I
cannot find any help on this. Does anyone know why this typically occurs?
Thanks,
Debbie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top