error 3027

[Merco]

i have converted a front-end with linked table to an MDB file to a
front-end database (MSACC2000) with linked table to SQL 2000.

I have both put primary keys and timestamp in my tables but this
recordset is still read only.
StrSQL = "SELECT DBProd.*, SchedeArticoli.GIACENZA,
[dbprod]![qta]-[dbprod]![qtaprelevata] AS Diff" _
& " FROM ODL INNER JOIN (DBProd LEFT JOIN SchedeArticoli ON
(DBProd.IDMagazzino = SchedeArticoli.IDMAGAZZINO) AND (DBProd.Cod_F =
SchedeArticoli.IDCODICEARTICOLO)) ON ODL.RowId = DBProd.RifRowIdODL" _
& " WHERE (((DBProd.Cod_F) Like '" +
[Forms]![PrelievoDaODL]![Codice] + "') AND ((nulltostring([Commessa]))
Like '" + [Forms]![PrelievoDaODL]![Commessa] + "') AND
((ODL.Stato)='A') AND ((DBProd.ODLTipo) Like '" +
[Forms]![PrelievoDaODL]![Tipo] + "') AND ((DBProd.ODLNumero) Like '" +
[Forms]![PrelievoDaODL]![Numero] + "') AND
((DBProd.Qta)>[dbprod]![qtaprelevata]));"

Set db = CurrentDb
Set Rs = db.OpenRecordset(StrSQL, dbOpenDynaset, dbSeeChanges)

but the same SQL in the MSSQL enterprise manager let me update the
fields...
SELECT dbo.DBProd.*, dbo.SchedeArticoli.GIACENZA AS Expr1,
dbo.DBProd.Qta - dbo.DBProd.QtaPrelevata AS Diff
FROM dbDL INNER JOIN
dbo.DBProd LEFT OUTER JOIN
dbo.SchedeArticoli ON dbo.DBProd.IDMagazzino =
dbo.SchedeArticoli.IDMAGAZZINO AND
dbo.DBProd.Cod_F =
dbo.SchedeArticoli.IDCODICEARTICOLO ON dbDL.RowId =
dbo.DBProd.RifRowIdODL
WHERE (dbo.DBProd.Cod_F LIKE N'%') AND (dbDL.Commessa LIKE
'GEN') AND (dbDL.Stato = 'A') AND (dbo.DBProd.ODLTipo LIKE N'%')
AND
(dbo.DBProd.ODLNumero LIKE N'%') AND
(dbo.DBProd.Qta > dbo.DBProd.QtaPrelevata)

THE QUESTION IS:
IS THERE A WORKAROUND WITHOUT MODIFING THE SOURCE CODE ?

thanks