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

I suggest posting details of your linked Table (Fields, PK) and your local
Table (Fields, PK), the SQL String of the Query and which Table you want to
add the Record too.

Note that "of course read only" is incorrect. I (and probably millions of
users around the world), add / update Records in SQL Server databases via
linked Tables in Access.

--
HTH
Van T. Dinh
MVP (Access)




"Chris" <(E-Mail Removed)> wrote in message
news:79bc01c4767d$4314c240$(E-Mail Removed)...
> 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