We are still using 32bit DB2 database server and we are dependent on Access 2000 driver to access/update/delete data from DB2 tables since the driver is old and cannot work on Windows 10 computers.

We have a requirement to change the year of data entry each year. So my plan is to somehow automate the process.
Each year we create data entry tables which have the same prefix in the name but different year, like so:

MY_DATA_ENTRY_TABLE_2017
.
.
.
MY_DATA_ENTRY_TABLE_2019

Is it possible to somehow check if a given table exists with a predetermined name(MY_DATA_ENTRY_TABLE_2019 for example), and if it exists on DB2 server, Access 2000 attaches it automatically with some VBA code?

Additionally if such script can exist, can I call it from VB.NET since the application I am building is made in VB.NET?