ExecuteNonQuery : Error Cannot open action query ''

[fniles]

I am using VB.NET 2005 and MS Access.
I use OLEDbCommand ExecuteNonQuery to delete a record from a database.
Whenever the program gets a message, it creates a new thread to process that
message.
In the thread I open the database, then process the message.
Sometimes I get an error "Error Cannot open action query ''". Why can it
execute the query and how to fix it ?
Thank you.

Public Class Best
Dim clsEachMessage As New EachMessage

EachMessageThre ad = New Threading.Threa d(AddressOf
clsEachMessage. ProcessMessage)
:

Public Class EachMessage
Dim adoConOLE As OleDb.OleDbConn ection = Nothing
Private m_cmd As OleDb.OleDbComm and

Public Sub ProcessMessage( )
adoConOLE = New OleDb.OleDbConn ection
With adoConOLE
.ConnectionStri ng = g_dbPath
.Open()
End With

m_cmd = New OleDb.OleDbComm and
With m_cmd
.Connection = adoConOLE
.CommandText = sSQL
End With
m_cmd.ExecuteNo nQuery() --Error Cannot open action query ''

[Cor Ligthert[MVP]]

Hi,

Do you have in the other thread altready a OleDB connection open?
Close that than first,

Cor

[fniles]

I open the connection in the beginning of each thread. And at the end of
each thread, I close the connection.
So you think the error "Error Cannot open action query ''" is because the
maximum connection has been reached ?

Thanks.

"Cor Ligthert[MVP]" <no************ @planet.nlwrote in message
news:3A******** *************** ***********@mic rosoft.com...

Hi,

Do you have in the other thread altready a OleDB connection open?
Close that than first,

Cor