Error 2147217887 -- "Errors Occurred" 
Author Message
 Error 2147217887 -- "Errors Occurred"

I am using disconnected ADO  recordsets, from an Access database .
Whenever I user a statement like this:

rs1!MyField1 = rs2!MyField2

I get Error 2147217887 -- "Errors Occurred"

But this statement work OK:
   rs1!MyField1 = rs2("!MyField2").value

Also, this works OK:
   Dim x as variant
   x = rs2!MyField2
   rs1!MyField1 = x

Also , the same code against SQL Server 7.0 (same database) works OK.

The CursorLocation = adUseClient
CursorType:=adOpenStatic, LockType:=adLockBatchOptimistic
The connect string is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\
... \mydatabase.mdb;"

I have MDAC 2.1.2.4202.3 installed.

Does anyone have any idea what the problem is. Any help is greatly
appreciated.

-- BobC



Fri, 22 Nov 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Next Problem - Error 80040E21 "Error Occurred."

2. -2147217887 Errors occurred

3. Errors Occurred - 2147217887

4. error 80020009 "exception occurred"

5. ADO msg "Errors occurred" after update

6. Error -2147217887: "Multi-step operation generated errors" error...

7. Error 3043: "Disk or Network error"

8. Access 2000 Error - "Application Defined Error"

9. Printing Error "Run Time error 486"

10. Error 525 "Data Access Error"

11. Error message : "Error in loading DLL"

12. Error 3043 "Disk or network error"

 

 
Powered by phpBB® Forum Software