[AccessD] ADO OpenRecordest with Update

Hi Jack,

Not sure what you're trying to do here, but I don't believe you can open a
recordset with an UPDATE sql statement; since recordsets simply present you
with requested data for review, processing, whatever.

If you simply want to run the Update SQL so that the records get updated,
you can use "DoCmd.RunSQL mySQL".  HTH.

Best Regards,

Julie Schwalm
Backroads Data
www.backroadsdata.com
785-594-6807
----- Original Message -----
From: <Drawbridge.Jack at ic.gc.ca>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, October 15, 2003 9:45 AM
Subject: [AccessD] ADO OpenRecordest with Update


>
> Is it possible to have an ADO openrecordset ("sql_string") where the
> sql_string is an UPDATE statement? I see examples with SELECTs but no
> Update.
>
> We are getting error 3219 Invalid Operation
>
>  mySql = "UPDATE MyTable SET item_ref_date = Now()
>   WHERE item_id = 16;"
>
> Thanks
>
> jack
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>