ADO DB update problems

[rockies1]

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?

[preeti]

What are the errors and SQL statements?

Preeti

[rockies1]

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.

[preeti]

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