I seem to be having problems updating a record to SQL Server 2000.
using VB5.

I get the following error

Error 3073 - Operation must use an updateable query

Here is my code to connect to SQLSERVER

db = OpenDatabase(vbNullString, False, False, "ODBC;Driver=SQL Server;
Server=OEMCOMPUTER;Database=AKREVA;UID=sa;PWD=;DSN=AKREVA;")

recordset SQL goes here

db.Execute(Update SQL goes here)

Any ideas would be greatly appreciated

Thanks

Aman Raina