I have linked a table from oracle to my MS access db using an ODBC connection to Oracle. The table name is CFR_Pivot. I want to have vba code or a macro to refresh the linked table when the user opens a form.
Question: please provide me with the syntax for vba or the steps you recommend to use in a macro.
Thanks for your assistance in advance