Operation must use an updatedable query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an linked table, i create an query from the linked table. In my
programming i get an error saying "Operation must use an updateable query". I
found it strange it worked perfect for the first time or second time, it did
sent the data. and then after this popup message comes up. I am not linking
with any other table, just the link table.

this is urgent if any of you know how to fix the problem please tell me asap.

Mel
 
mel said:
I am using an linked table, i create an query from the linked table. In my
programming i get an error saying "Operation must use an updateable
query". I
found it strange it worked perfect for the first time or second time, it
did
sent the data. and then after this popup message comes up. I am not
linking
with any other table, just the link table.
Click to expand...
Hi Mel,

Did you refresh the link and are you linking
to a SQL Server table.

If so, then you lost the "virtual primary key"
when you refreshed.

Delete the link, then relink (so you have to
reassign the "virtual primary key.")

good luck,

gary
 
Back
Top