I have a MSAccess VBA application that is querying multiple Oracle tables. I need to allow the user the ability
to update records which are displayed in a continuous subform. I am able to accomplish this by using OraOLEDB and then setting the Unique Table property of the form to one of the tables contained in the Recordset.
The problem is when I update a record I want to be able to resync information associated with the row effected.
I have searched the internet and this site, but I have been unable to generate the code necessary to accomplish this.
cnnDB.Provider = "OraOLEDB.Oracle"
cnnDB.Open "raja", "hlsd", "h_l_s_d17"
rst.CursorLocation = adUseClient
rst.Open sqlstmnt, cnnDB, adOpenStatic, adLockOptimistic, adCmdText
Set Me.Recordset = rst
Me.UniqueTable = "LLARCHIVE_ANIM_US8592"
Me.ResyncCommand = sqlstmnt + keyfield = ?