Hi:
I am ultimately going to upgrade our Master Database files from .mdb to Access 2016 .accdb) however at present our database is split (Programs in one location and Data in another) the fact that they both sit in the same area is irrelevant as if you move the data files the program files are looking for the data in a specific folder on a specific drive.
Firstly: Is there a way to "edit" the location information in the p[rogram files so that I can move the program files somewhere else and just update the location of the data files?
If not then I (under test) checked to see if the programs and data files would upgrade to .accdb file format which was fine hoever the when I fired the program files the database was looking for the data as .mdb files and not .accdb.
Any thoughts/suggestions would be helpful.