ADO DB update problems

I have a VB6 front-end that connects to an Access97 DB and uses a query there as it's source.

When I try to update the data, I keep getting errors...

I'm happy to post the code if needed...

Anyone have any ideas?

What are the errors and SQL statements?

Preeti

err.number - -2147217842
err.description = "The change was canceled during notification; no columns were changed"

There is no SQL. I am using the ADO data control to access an query in an Access DB.

Are you able to run the query from Access? If so, try running the query from VB instead of having the query in Access. If this works, then it is a setting with your ADO control, if it doesn't work then it's the way that VB is accessing (or sending) your query.

To run the query from VB:

Dim adoCon as new ADODB.Connection
Dim sSQL as String

'Fill in the information to connect to
'your database
adoCon.ConnectionString="DSN=;UID=;PWD=;"
sSQL = "UPDATE ..."
adoCon.Execute sSQL

If the SQL Statement will not work, you should get the same error as a runtime error.

HTH,

Preeti