Jim-
It would be better to split it - that way Dropbox only has to keep your data synchronized. You can put the front end in any other folder - put a copy on all machines that you want to be able to run the app. Just make sure Dropbox is installed on all of them.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Nov 12, 2014, at 4:47 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
I put the database in the folder and it working great. But you are suggesting that I still split the database? But I am unclear about what you said for putting the data back end in the dropbox folder on the computer. Where are you suggesting the FE be stored?
Jim Wagner
On Wednesday, November 12, 2014 8:39 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim-
Actually, you can put the database - or just the data back end - in your DropBox folder on your computer. You'll update locally, but DropBox will keep a synchronized copy in the Cloud and will automatically update it on any other device where you're signed in with the same ID. Sounds like an ideal solution for you.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Nov 12, 2014, at 4:21 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have never used dropbox before. I signed up and put a copy of the database in the folder and it was really fast. I am not convinced I was really in dropbox.
Jim Wagner
On Wednesday, November 12, 2014 8:10 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim-
If OneDrive isn't fast enough, you could try DropBox or even Google Drive.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Nov 12, 2014, at 4:02 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Well Splitting the database is a good idea. I will give that a try. I will let you know how it turns out.
Thank You
Jim Wagner
On Wednesday, November 12, 2014 7:57 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim-
Consider splitting your database and then just put the "data" database in OneDrive. Use linked tables from the front end running on your local machine. That should dramatically improve performance (you won't be loading forms, reports, and code over the internet), but it still might be to slow.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Nov 12, 2014, at 3:50 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
So I have mapped my onedrive on my work desktop and tried to open it as a network drive. After going through the trusted locations issues, I tried to add records and run some processes, it was painfully slow. So that does not seem like a viable solution.
Jim Wagner
On Wednesday, November 12, 2014 7:16 AM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
John,
It opens but with errors. I have a splash screen that opens and then closes after performing some actions. Then the errors show up. Then I have a read only bar at the top, that wants me to save as to a folder. I guess that I could store it in onedrive and just move it out of the folder every day.
Jim Wagner
On Wednesday, November 12, 2014 5:23 AM, "josemezayasoc@yahoo.com.mx [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
hello
My name is José Antonio and i am new in the Access environment, one way i may suggest you is Google Drive. Put it there and wherever you use it it will be synchronized and you will allways have your data uupdated. And remeber that it's free.
By the way, do you know if we can find this kind of service in yahoo ?
Best Regards and good luck, tell me if it works for you.
-----Original Message-----From: luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>Subject: [MS_AccessPros] Portable AccessHello all,I have a database that I enter in my tasks and projects for work. It is a personal database that I keep on my flash drive. I back it up in OneDrive each day after using. I was thinking that there has to be a better way of getting to my database so that has more portability. Something that I could open on my work laptop or my work desktop or my personal desktop or laptop.I was looking at Azure but that seems a bit much for such a small database. The cost does not seem to be worth the 25 MB footprint. Although it would be nice to learn how to use it. I have SSMS on my work machines and my laptop. But I am not sure how that would keep the Access database portable.I do not have a web location to store the Access database either. What are some thoughts that the forum users have?Thank YouJim Wagner
__._,_.___
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 (16) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar