Adding a new record to a query in access project

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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.
 
Back
Top