-
Feb 21st, 2018, 09:50 AM
#1
Thread Starter
Junior Member
[RESOLVED] Building a ACCESS connection string with code in vbs 2015
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|