Adding a new record to a query in access project

From: Chris (anonymous_at_discussions.microsoft.com)
Date: 07/30/04


Date: Fri, 30 Jul 2004 14:36:24 -0700

I have a query that has a local table and a linked SQL
server table that is of course read only. I can update
fields in the query but I cannot add a new record in the
query as long as it is attached to the linked table.

Any suggestions or work around would be appreciated