Avatar of Reyesrj
Reyesrj
Flag for Guam asked on

MS Access 2016 Split Form

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.
Microsoft 365Microsoft Access

Avatar of undefined
Last Comment
PatHartman

8/22/2022 - Mon
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

I'm not 100 % positive, but I don't think ... you can have a shared backend on a remote OneDrive, meaning that Access does not support that connection.

As a side note, what exactly do you mean by you 'split' the Form ?
Reyesrj

ASKER
I meant to say splitting the database.
ASKER CERTIFIED SOLUTION
PatHartman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Reyesrj

ASKER
Thank you for pointing this out.  What you said and the way you explained it, makes sense.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
PatHartman

The nice thing about Citrix is that there won't need to be any application changes.  Switching to Sharepoint lists will be a minor change.  Everything else is a rewrite.