access query cannot edit data

I'm working on a linked Oracle table that I pull into Access. I can edit data while in a table, however, when I run a query on the linked Oracle table, I cannot edit or add data to the query. I have checked properties to check to see if the records are locked and they aren't. If I just import the linked table, I can then edit and add data to the query. I don't want to do this, because I'm trying to have realtime access for users. What could be the matter?

I think you have to run and update or and sql query to do that.....

I have tinkered with linked tables in access and there is considerable differences between access's sql and mysql and oracle sql.

edit check the warning at the bottom of this page

Quote:

---

Originally Posted by NooNoo

I think you have to run and update or and sql query to do that.....

I have tinkered with linked tables in access and there is considerable differences between access's sql and mysql and oracle sql.

edit check the warning at the bottom of this page

---

Thank you NooNoo, I will see if that works tomorrow at work. I've been banging my head against my desk with this. I've looked at some books without any success. :thumbs: