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?
