Editing a Linked Table Through Subform

[cameron.scrimgeour]

Hi

I have a subform on my form. It is populated by data from a query on a linked table. This is an table that is in my oracle DB.

I cannot directly edit the data through the subform and I belive this is because you cannt edit a linked tables data. Is this correct?

It would make my form so much better if I could edit the data directly through the subform, so is there any way around the problem?

Cheers for any help!

 

[DCrake]

Because your source table is linked to an Oracle database I imagine that that the data you are looking at is read only you may need to look at the Oracle side of things to see if you can change the permissions to be able to update it through Access. However this may be dangerous as you may not be aware of any hidden processes in Oracle that take place when certain data is changed.

David