[AccessD] Re: Update table with update query

Robert L. Stewart rl_stewart at highstream.net
Fri Feb 6 12:15:41 CST 2004


Yes it is.  You will probably need to do it in code.

Robert

At 12:00 PM 2/6/2004 -0600, you wrote:
>Date: Fri, 6 Feb 2004 12:56:58 -0500
>From: Randall Anthony <ranthony at wrsystems.com>
>Subject: [AccessD] Update table with update query
>To: accessd at databaseadvisors.com
>Message-ID:
>         <5F21A4E8B8DD734992EF9E70AC9D3064128A40 at mail2.wrsystems.com>
>Content-Type: text/plain
>
>Hey group,
>I have a problem that seems a no-brainer.  I use a select groupby query to
>get a recordset.  I then use a second query with the first query and the
>target table in order to update the target table.  I thought this should
>work no problem, however I get an "Operation must use an updatable query"
>error.  Is this one of those you can't get there from here things?  Using
>A97.




More information about the AccessD mailing list