Why can't I save a records using DataEnvironments

[Leebo]

We are currently developing an app in VB6 ENT SP5 on a Win2K Pro PC with an Access 97 converted to Access 2000 database.

As this was a fairly important client development project we decided to go with the flow and stop using DAO and try ADO within a DataEnvironment.

Everything started OK we were amazed at how we could drag and drop fields from the DE to forms and reports with fairly little code or effort. Then we tried saving a record and now get the odd little error message...

.Run-Time Error '-2147024773 (8007007b)': The filename, directory name, or volume label syntax is incorrect.

What the hell have we done wrong?

The code we used was something like this:


Private Sub Command2_Click()

DataEnv.rsWIPData.Save

End Sub

Any help would be great!!!

Many Thanks in Advance

Leebo!

[TheBao]

Goto your WIPData command property:
1. Click on Advanced tab, change Lock Type to 3- Optimistic.
2. Use the method Update instead of save:

DataEnv.rsWIPData.Update

Regards,
TheBao