Hey everyone, so my very simple database has become a lot bigger than originally planned. Now my boss is asking I move the database to another server so additional outside sources have access to it. The problem I quickly figured out is that if I move the back end of the database, the file path is no longer valid on the front end. Could someone provide some help in how I can update the file path on the front end so it works correctly once the back end is moved to where it needs to go?
My database has two tables; Table: Inventory & Table: Users
Access 2010
Thanks in advance for help that is offered.