Error 3073 : Updatable Query required

Error 3073 : Updatable Query required

Post by Markus Weiger » Sun, 17 Sep 2000 04:00:00



Hi!

I've developed a database application for Windows 2000 with VB6+SP4, which
uses a Connection object to open a database connection via Microsoft Jet and
then I'm uisng several recordsets with client-sided cursor and
adLockOptimistic mode.
Everything works fine with Windows 2000, but with Windows NT 4 + SP5 every
recordsets reports an error 3073, the query wasn't updatable. So I'm unable
to save any data...  I have already tried MDAC 2.5 and MDAC 2.5 SP1, but the
error continues.

Could anybody help me?

Thanks

bye

Markus

 
 
 

1. Error 3073 - Operation must use an updatable query

I'm confrontating the following error trying to modify a table in
dbaseIII format linked thru Access 97, and accessed by VB6 using DAO 3.5:
Error 3073- Operation must use an updatable query

Have a query in Access that simulate the process of inserting new records in
the Dbase table, and it work fine from Access97 but when i put the same SQL
string and try to execute it from VB6 it doesn't work, but instead send me
the error before mentioned

The code as follows:
'====================
        Set dbs = OpenDatabase(Setup.dbdir)

        Ejecuta = "INSERT INTO JCTRANSA ( JCTRNUM, JCTRSCOD, JCTRPROVEE,
JCTRINVOIC, JCTRDATE, JCTRAMOUNT, JCTRDESCRI, JCTRTIPO, JCTRPROVE1 ) " & _
                    "SELECT Rec1.NoProyecto, Right([CuentaCosto],4) AS
Expr1, Rec1.NoSuplidor, DetalleRecibo.NoFactura, DetalleRecibo.Fecha,
DetalleRecibo.Monto, Rec1.Descripcion, 'F' AS Tipo, Rec1.Compania " & _
                    "FROM DetalleRecibo INNER JOIN Rec1 ON
DetalleRecibo.RegOC = Rec1.ID " & _
                    "WHERE ((Rec1.NoProyecto<>'ZZ') AND
(DetalleRecibo.Fecha>=#" & CDate(varDesde) & "#) And
(DetalleRecibo.Fecha<=#" & CDate(varHasta) & "#) AND (Rec1.Sociedad = '001')
AND (DetalleRecibo.StEnvioCostos=False));"

        dbs.Execute Ejecuta
'================

TIA,

Alvaro Lao

2. how to use the bookmark of recordset?

3. Operation must use an updatable query. (Error 3073)

4. Data Acces and SQL Server 2000/COM+

5. Run time error 3073 -Operation must use an updatable query

6. update 1 record takes more than 30 seconds

7. Operation must use an updatable query 3073 - ODBC Error

8. Error 3073, Operation must use an updatable query

9. Error '3073' Must use updateable query

10. "Error 3073: Operation must use an updatable Query" message for Update/Delete with CDaoDatabase / CDaoRecordSet