MS Access 2016 Split Form
Posted on 2016-10-01
I created an Access 2016 database. The database was created on my workstation at work and I saved it to my local OneDrive folder which syncs to my online OneDrive account. From my workstation I split the form so my wife and I could enter data while at home. We both have a local OneDrive folder one our laptops. I shared the split form and the back end tables with her. The problem is that the tables are pointing to the local folder on my workstations at work and we can't access the forms from home. How do we access the shared split form from home?
I also, made a backup before splitting the form. I copied the database on to my laptop and split the form from there with out any problems. But when I created a remote connection (\\MyLaptop\AccessDataBase) to my laptop from her laptop, I get the same problem. The tables are pointing to the local folder on my laptop (C:\user\Me\Documents\Access Database) and she can't access the split form. The split form will open but the forms and queries will not open because her laptop does not recognize the path (C:\user\Me\Documents\Access Database). I tried sharing the folder and the split form so it will connect using a shared name but that still does not work.
Please help and thank you in advance.