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 delete this linked table so that it is no longer connected to my Access DB when users wish to remove it.
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