?
Solved

MS Access 2016 Split Form

Posted on 2016-10-01
5
Medium Priority
?
100 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.
0
Comment
Question by:Reyesrj
  • 2
  • 2
5 Comments
 
LVL 75
ID: 41824913
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 ?
0
 

Author Comment

by:Reyesrj
ID: 41825011
I meant to say splitting the database.
0
 
LVL 41

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 41825802
Access cannot work on shared network drives such as OneDrive and DropBox.  The technology does not work the way Access requires.

The best solution for a small number of users is to find a provider to host a Citrix solution.  With Citrix, the Access application FE will run on the Citrix server and so will the BE.  Your PC sends keystrokes to the Ctirix Server and the Citrix server sends screen images to you.  Data isn't transferred.

Another option if you don't have a lot of data (tables less than 5,000 rows), you can create a Sharepoint site and import the data from your BE to Sharepoint lists.  That will allow remote users to share the same database.

Aside from those two, you are looking at a complete rewrite.  Access web apps are completely different from access client/server apps and there is no conversion path.  The other web option would be to create web pages to replace your Access FE forms and reports and use SQL Server or MySQL as the BE.
0
 

Author Closing Comment

by:Reyesrj
ID: 41825804
Thank you for pointing this out.  What you said and the way you explained it, makes sense.
0
 
LVL 41

Expert Comment

by:PatHartman
ID: 41825806
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.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question