How to resolve name of linked table in Access 2000 with VB6 code?

[kutlesh]

Tables exist originally in MS SQL Server, and people here tend to link them as ODBC data-sources with an Access 2000 table name, not necessarily same as the name of the table in SQL Server, which becomes confusing, misleading and error prone.

And you need to re-link the tables for the new year, each year, and change the name so that they can be found by the Access 2000 macros and queries.

For example, lets say, table in MS SQL Server is called, MY_TABLE_2022 for this year. In Access it is called for example THE_TABLE_2000 but it links to MY_TABLE_2021 for the previous year in SQL Server.

Now you will need to

1. link MY_TABLE_2022,
2. rename THE_TABLE_2000 to THE_TABLE_2000_something,
3. rename MY_TABLE_2022 to THE_TABLE_2022 and
4. delete the dummy link THE_TABLE_2000_something,

because macros/queries reference table called THE_TABLE_2000 in Access 2000.