Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1390
  • Last Modified:

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
1
Lou Dufresne
Asked:
Lou Dufresne
1 Solution
 
PatHartmanCommented:
To delete a table -

DoCmd.DeleteObject acTable, "ImportErrors"

Open in new window


This will physically delete a local table or simply delete the link for a linked table.
0
 
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
PatHartman,
   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
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now