I have an access database and I have a .txt file that has the path stored in it.
The file is already in C:/Program Files/ThisOtherProgram/Config.txt and it contains this line; 4,Z:\DataPath\Data.mdb
This is the path that I would like my program to access the database with because depending on which computer you use the path may be different to my database.
How would I open this file, find "4, X:\ThePath\To\The\Database" and use that for my database connection location when my program loads?
Thanks for any code or help you can provide