I had a problem in while updating two tables like Master & Transaction in SQL Server 7.0 throgh ODBC using VB6.
I used the command as appended below:

Dim MyDb As Object
Dim SqlString1, SqlString2 As String
Set MyDb = OpenDatabase("", dbDriverNoPrompt, False, "ODBC; DSN=SQL; UID=User; PWD=Password")

SqlString1 = "UPDATE Master SET = 'Newvalues' WHERE nId = IdValue"
SqlString2 = "UPDATE Trans SET = 'Newvalues' WHERE nID = IdValue"

MyDb.Execute SqlString1
MyDb.Execute SqlString1

When Execute the SqlString, the following error message appeared
'3073 - Operation must be use an updatable Query'

Please help me, Thanks in advance.

Regards,
Ragu.