Computer Database Sync Issue - Directory Name

[WayneCrimi]

I have several Access databases and files I want to use on 2 different computers. One computer is set up as C:\users\admin\OneDrive\ etc... . That's where all my files are located. The other new one is set up as C:\users\wcrim\OneDrive\ etc... There are linkages in various queries in Access set up to point to the first one. So when I run queries on the 2nd computer, files can't be found. How do I change the directory name on the 2nd computer to "admin" instead of wcrim so that everything will remain in sync between the two computers .and my database linkages work because they are all

Continue reading...