Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-11-2019, 02:39 PM   #16
DatabaseTash
Newly Registered User
 
Join Date: Jul 2018
Posts: 95
Thanks: 24
Thanked 0 Times in 0 Posts
DatabaseTash is on a distinguished road
Re: Moving Access Database to OneDrive

Quote:
Originally Posted by Micron View Post
Didn't somebody here write a good treatise about 3 months ago on why you should NOT do this? I believe it covered WIFI as well. Plus, if we're talking about a split db and the back end is on OneDrive, I'd say that's about 10x worse than everyone sharing the same front end over a network.
Why is that the case? Aren't you just appending or updating records?
The plans are not stored in the database, just the a record of their main details. They are stored separately in another folder to avoid filling the database. There are about 20,000 plans. I think it is quicker and more accurate to run the script for the links. When I add plans I can add 30 to 100 plan records at a time.

DatabaseTash is offline   Reply With Quote
Old 11-11-2019, 02:46 PM   #17
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,308
Thanks: 115
Thanked 3,095 Times in 2,813 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Moving Access Database to OneDrive

Quote:
Originally Posted by DatabaseTash View Post
The plans are not stored in the database, just the a record of their main details. They are stored separately in another folder to avoid filling the database. There are about 20,000 plans. I think it is quicker and more accurate to run the script for the links. When I add plans I can add 30 to 100 plan records at a time.
Whilst that is as it should be, it has no effect on the earlier comments. Data corruption will happen at some point using a storage location in the cloud.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)

Last edited by isladogs; 11-11-2019 at 03:22 PM.
isladogs is offline   Reply With Quote
Old 11-11-2019, 03:16 PM   #18
DatabaseTash
Newly Registered User
 
Join Date: Jul 2018
Posts: 95
Thanks: 24
Thanked 0 Times in 0 Posts
DatabaseTash is on a distinguished road
Re: Moving Access Database to OneDrive

THANK YOU so much everyone!! You all have a wealth of information. So glad I checked first.

This forum is awesome!!!

Thank you

DatabaseTash is offline   Reply With Quote
Old 11-11-2019, 03:41 PM   #19
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,567
Thanks: 58
Thanked 1,437 Times in 1,418 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Moving Access Database to OneDrive

Quote:
Originally Posted by DatabaseTash View Post
THANK YOU so much everyone!! You all have a wealth of information. So glad I checked first.

This forum is awesome!!!

Thank you
Hi. We're all happy to assist. Good luck with your project.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-11-2019, 05:13 PM   #20
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,316
Thanks: 15
Thanked 1,600 Times in 1,520 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Moving Access Database to OneDrive

If it is possible to create a folder on OneDrive that you can update and share but that NO ONE ELSE can update, you could use OneDrive to share. As long as OneDrive ALWAYS downloads a copy and opens it locally, you are fine. If OneDrive tries to open the file in the OneDrive folder, this will not work. That is the question you need to have answered. I can't answer it and I don't think anyone else did either although Doc probably came close. I wouldn't even consider risking allowing multiple users to update the app serially. Too much could go wrong.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
DatabaseTash (11-11-2019)
Old 11-11-2019, 08:38 PM   #21
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,720
Thanks: 93
Thanked 1,712 Times in 1,585 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Moving Access Database to OneDrive

Typical management viewpoint - from someone who doesn't understand that the cloud is a "one size fits all" solution to a wildly variant world. In my 40+ year career, I have NEVER seen any manager with an accounting or business background get this right until it bites them on the arse because of that decision. But I have never found the words to make them hear the truth. They see what they want to see until they get burned, then ask you how to fix their error.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
AccessBlaster (11-12-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I link photos stored on Office 365 (OneDrive, etc.) with an Access Database? Plaxerous General 20 08-26-2019 01:15 PM
Moving Access database to another computer Raed1 General 1 10-03-2018 11:45 AM
Question Moving MS Access 2007 database from one to another computer sandrao.xx General 5 04-27-2011 11:39 AM
MS Access Database slow after moving to another server. trethab General 3 07-22-2009 02:28 PM
moving access to database jlabre01 SQL Server 3 06-24-2008 06:37 AM




All times are GMT -8. The time now is 04:10 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World