VB6 ADODB Fails with SQL Compact: Multipe-Step operation generated errors?

Got this working now: Changing mDbConnection. CursorLocation = adUseClient to mDbConnection. CursorLocation = adUseServer worked!

I'm not 100% sure the error is from this code rather than something after it and this is the "last known good" type position. Most common causes of the error: You are implicitly converting data into the wrong datatype (e.g. An alpha string value is being inserted into a numeric field.) You are inserting a value with a wrong format (tends to happen on dates most frequently) A null value is being inserted into a field that does not allow nulls. You have exceeded the max length of the field with a value.

(e.g. Sticking a string 50 characters long in a 10 character field) Also, there is nothing catching an error if the connection is not open.

Security (using Integrated Security instead of a username/password) or as Belliez said, the Cursor Location.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.