Dear friends,
I have been developing an application which records all my operation in an access db file. For the reporting part, I also use a workbook that connected the db file with querry and getting all necessary info from different tables that I created in access db.
Since we will be working on multiple projects, in every single time starting the app, the db file is copied in our server together with the workbook as a new (but preserving the all contents and macros). Afterwards, I cannot update the source of access db (in the workbook) despite the fact that tried really hard with vba coding. Rather than doing this source address update manually (because evertime I need to goto querry properties --> Data source settings --> Change Source button and change the db address) which I cannot ask my users to perform, I am seeking a proper approach in vba to get this done. So, both db and workbook files are stored together in a diffent folder all the time when commencing a new project.
I would kindly like to ask you professionals to guide me on this hard matter.
Thank you all
Bookmarks