I have a DataEnvironment control that creates a DBGrid 6.0 control. The Control is based on an SQL statment that grabs data from a local Access 2000 database.

I've set the Command Object's LockType = adLockOptimistic so that it will support updates to the database. Now, whenever a user retypes in a field, I get the following error - "Error Occurred while trying to update the column value". I have added NO updating code and really don't know what event to add it to if I had any. How can I write a value back to the database after a field looses focus after being changed?

Thanks!