Solved

MS Access 2016 Split Form

Posted on 2016-10-01
5
56 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 35

Accepted Solution

by:
PatHartman earned 500 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 35

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Find out what Office 365 Transport Rules are, how they work and their limitations managing Office 365 signatures.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 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