Lou Dufresne
asked on
MS Access 2013, Delete and ODBC table using a macro or code
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
Ldufresne
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
Ldufresne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks this worked perfectly
I am placing another request out there to refressh an ODBC linked table. Please search for it If you know the code
Ldufresne