David-
First, it's not a good idea to put both the front end and the back end on a server. The front end should be in a local folder, with the back end on the server.
BUT because you're using OneDrive, if you have installed the OneDrive app on your machine, you should see a OneDrive folder on your hard drive on all registered machines. That folder on each machine is a COPY of the files in OneDrive - and the app will sync any updates you do back to the OneDrive cloud - and other machines using the same ID will eventually be updated. DropBox works the same way.
So, I assume you sign in as "Papa" on your the machine at your grandchildren's house. I think if you're using Windows 10, you don't need a separate app, but Win 10 syncs any OneDrive files based on the logged in user. I don't know if you can separately install the app and login to the app with a different user ID, but you could try that on your "Papa" account. Go to http://onedrive.live.com/ and click Download to see what it does. If you can't do that, you'll have to create a "David" user ID on the grandchildren's machine.
Having said all that, you should be aware that any back end stored in the cloud like this (OneDrive, DropBox, etc.) CANNOT be shared with multiple users. When you open your app on one machine, it opens the back end for update - and that may either lock all other users out or end up with a conflict if another user opens the app while you have it open.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On May 26, 2017, at 4:13 PM, david.pratt@outlook.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have split my database into FE and BE but this causes a problem when I try to work on the application from multiple computers. I keep the database files in my MS OneDrive cloud account while I work on it from my main working computer. I was hoping to just be able to use this same approach when working from a different computer. The problem is that my logon name is different on the two computers.
When I am working at home on that computer, I am "David". When I am working from where my grandchildren live, on that computer, I am "Papa". Thus when my application is trying to find the BE files it is looking for "Users/David/OneDrive/AccessFiles". On the other computer it should be looking for "Users/Papa/OneDrive/AccessFiles". How can I resolve this so that I can work on the databases from multiple computers? Should I just create another logon ID name of "David" on the second computer or is there a way to do this so that I can access the application from any computer? Currently the BE and FE are located in the same directory.
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar