Connector error 80040E09

[Paul Owen]

We have developed a front end program in VB that works absolutely fine on 3 development systems, is the test area with a duplicate of the data from the main database, the problem is:

When we take the code to the 'live' site and try and add a record to a particulat table we get the above error, the same code/exe on a different database server but with the same data doe snot generate a fault.

the fault occurs when we do a .update to an ado control as follows

.addnew
!field1 = "blah" and so on for all fields
.update

at the update it fails on one server but not any others, same table structure same data. if I build an sql insert command for the same data as above and 'execute' it on a connection it works, just does not seem to like .update

Anyone got any ideas?

Regards

Paul