We help IT Professionals succeed at work.
Get Started

MS Access 2016 Split Form

Reyesrj
Reyesrj asked
on
175 Views
Last Modified: 2016-10-02
Hi All,

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.
Comment
Watch Question
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE