Access problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Hood - 25 Aug 2006 14:38 GMT

This is a similar problem to one posted earlier but occurs with access.

I have some code under a 'save' button which is something like

myRs.fields("myField1").value = "XXXX"
myRs.fields("myField2").value = "YYYY"
myRs.update
myRs.move(0)

This works fine with the query myRs.open ("select * from myTable" ) which
returns about 2000 records.

However if the query is changed to myRs.open ("select * from myTable" where
reference = "ZZZZZ")
which returns only one record. The an error is given ' consumer's event
handler called a non-reentrant method in the provider'

Can anybody help with this

Many thanks

Reply to this Message

Alan Hood - 25 Aug 2006 15:55 GMT

I was mistaken in my reason for this error.

If the recordset is opened as a table eg.

myRs.open ("myRs", myConn, adOpenDynamic, adLockPessemistic,
adCmdTableDirect)

then it works.

If the adCmdTableDirect is ommited or an SQL query is used then the error
occurs.

Reply to this Message

Dmitriy Antonov - 25 Aug 2006 16:08 GMT

>I was mistaken in my reason for this error.
>
[quoted text clipped - 7 lines]
> If the adCmdTableDirect is ommited or an SQL query is used then the error
> occurs.

Try adCmdText with SQL query.

Dmitriy.

Reply to this Message

VB Forum / Database Access / August 2006

Access problem