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/
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/