Hi All,

I'll try to post one more time and to be a little more clear on what problem I am experiencing.

We have a Visual Basic 6 application accessing VFP 7 tables. Writing stuff in reading it from these tables. They are not a part of a database, just free standing tables.

We have around 150 clients and the majority of them have no problems running this program. However once in a while we get a client experiencing some kind of problems and we try and try fixing it.

The precise error they get is Error -2147217900 One or more errors occured during processing of command.

The line of code that gives this error is:

gconConnection.Execute lsDFSQL

And the operation it is trying to execute in lsDFSQL is:
"Insert into SomeTable (field1,field2,...field10) Values
(Value1,Value2,..Value10)"

This is the code from the top of the program

Public gconConnection As ADODB.Connection
Set gconConnection = New ADODB.Connection

gconConnection.ConnectionString = "Provider=VFPOLEDB.1;Data
Source=C:\SomeDir\;Collating Sequence=MACHINE;Mode=Share Deny None;"

gconConnection.CursorLocation = adUseClient

gconConnection.Open

We have tried to reinstall vfpoledb for VFP 7 (no luck). Updating their MDAC to MDAC 2.7 (no luck). Updating VFPOLEDB to version 8 (no luck).

This has worked for us before in similar situations, but not this time.

If anyone has seen this or has an idea why this might be happening please HELP.

Thanks.