How to Programmatically Delete Linked Tables from Backend Only

[AlexB123]

Happy Friday, everyone!

I am working on code that will help me set up different Front Ends to different Back End tables without manually importing tables or using the Linked Table Manager. I have already figured out how to automate the import and relinking functionality, but now I want to add a functionality to delete the links already in the database. However, I DO NOT want to delete the Linked Excel Sheets.

Is there a way to exclude linked Excel tables from the rest of the linked tables to be deleted?

Here is the link where I got the code to delete the tables:

https://www.devhut.net/2011/06/10/ms-access-vba-delete-all-linked-tables/

 

[xenou]

You should have tableDef properties to look at that tell you what kind of table/linked table you are dealing with. Probably the Connect property. I'd loop the tables in the DB (tabledefs collection) and check it out.

 

[AlexB123]

You should have tableDef properties to look at that tell you what kind of table/linked table you are dealing with. Probably the Connect property. I'd loop the tables in the DB (tabledefs collection) and check it out.

How would you do that? Just send it to the immediate window, or to a file? Is there a way to check that info in the GUI?

 

[xenou]

Using the immediate window is a good way to go. You can also print to the immediate window. Or to a message box.
For debugging in general in VBA see here:
http://krgreenlee.blogspot.com/2006/04/programming-excel-vba-debugging-for.html

For instance, you could create a small code snippet:

PSEUDOCODE

for each td in currentDatabase.TableDefs
    debug.print td.Connect

Then you can see what kind of values are in that property (as well as paying particular attention to the difference between the linked tables you are interested in, and the rest.