Hello. We make new tables each year with same structure but slightly different table data in MS SQl Server.
So if the table is called, MY_TABLE_2021, for this year it will be called MY_TABLE_2022. The only thing that changes is the year number in the table name.

We have a problem with maintaining Access 2000 application, and people here just copy the same 50 MB mdb file over and over again, when just the year in the linked table names changes.

I want to develop a VB6 script that will resolve the table name by getting it from the computer system time, or maybe simpler, just type the current year in a text box.

I am a relatively new to Access 2000 and don't know really where to start. Some guidance is welcome.

Any idea on the topic?