I am upgrading a Visual Basic 6 program. In this program there is a database " County Hunter - call.mdb" I have changed the database's used to accdb. The problem is....when a user install the program the database (CountyHuntersMaster.accdb, CountyHuntersCommon.accdb, and CountyHunter[Call].accdb are installed into a data folder.

When the user opens program for first time the CountyHunter data base has (their Call) replace the word [call ] in the database title. I have been trying to find an example of how to get the Connection string to be correct for the change:

Example CountyHunterCall.accdb is changed to CountyHunterK8EMS.accdb

I need to be able to make this change pragmatically as each user has a different call.

I am using Access 2016, and visual Studio 2015 to do this.

Can anyone point me in the right direction.