Solved

MS Access 2016 Split Form

Posted on 2016-10-01
5
73 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 36

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 36

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

749 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