Go Back   Access World Forums > Microsoft Access Discussion > General

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

I have an access database which is currently on our server and is used by about 18 people. The database is set with permissions and a auto-updating utility. Everyone except me uses a read only permission. The Database is a reference for plans and provides a link to the digital copy of each plan.

Management would like to move it to OneDrive. I have concerns with this though. Is it possible? Will it sync properly? Would I move the front and back end to OneDrive?

I also have a PowerShell script I run to insert the hyperlinks when new batches of plans are added. I was told that to run this script everyone needs to be out of the database. Will it still appear with the lock to show if someone is in the database when it is in OneDrive?

Does anyone have any experience with this? The database works like a dream now and I don't want it to be out of action.

DatabaseTash is offline   Reply With Quote
Old 11-10-2019, 05:44 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,461 Times in 1,442 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Moving Access Database to OneDrive

Hi. I don't think One Drive is a good place for an Access database, but since you said it's read only anyway, this may be an exception. Still, I would recommend thorough testing before committing to it.
__________________
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 online now   Reply With Quote
Old 11-10-2019, 06:01 PM   #3
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,246
Thanks: 29
Thanked 285 Times in 271 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: Moving Access Database to OneDrive

I doubt onedrive or Google drive will allow the lock file to remotely open and close.

AccessBlaster is offline   Reply With Quote
The Following User Says Thank You to AccessBlaster For This Useful Post:
DatabaseTash (11-10-2019)
Old 11-10-2019, 06:41 PM   #4
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 theDBguy View Post
Hi. I don't think One Drive is a good place for an Access database, but since you said it's read only anyway, this may be an exception. Still, I would recommend thorough testing before committing to it.
Thanks for the reply. I'm glad I am not alone in thinking this is a bad idea. Is it mainly the data syncing side of things that concern you about it?
DatabaseTash is offline   Reply With Quote
Old 11-10-2019, 06:53 PM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,461 Times in 1,442 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
Thanks for the reply. I'm glad I am not alone in thinking this is a bad idea. Is it mainly the data syncing side of things that concern you about it?
Well, keep in mind this. As far as I know, when you put a file on One Drive, a copy is placed on your hard drive. When you open the file, you're actually opening the local copy. One Drive then syncs the whole file to update the one in the cloud. So, if you were to share a multi-user db using One Drive, each user will actually update their own local copy of the BE, instead of the one in One Drive. During the synching process, you will likely get a lot of edit conflicts.

So, I was saying if your users won't be updating their local copy of the data because it's read only, then there probably won't be any data conflicts.
__________________
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 online now   Reply With Quote
Old 11-10-2019, 07:33 PM   #6
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

Thanks for your help theDBguy
DatabaseTash is offline   Reply With Quote
Old 11-10-2019, 08:01 PM   #7
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,246
Thanks: 29
Thanked 285 Times in 271 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: Moving Access Database to OneDrive

I did see an ODBC driver for the Google Drive, but I don't see how you would keep a persistent handshake as you would with a SQL server.

AccessBlaster is offline   Reply With Quote
The Following User Says Thank You to AccessBlaster For This Useful Post:
DatabaseTash (11-11-2019)
Old 11-10-2019, 08:53 PM   #8
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,247
Thanks: 10
Thanked 232 Times in 220 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Moving Access Database to OneDrive

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.
Quote:
I also have a PowerShell script I run to insert the hyperlinks when new batches of plans are added.
Why is that the case? Aren't you just appending or updating records?
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 11-10-2019, 09:08 PM   #9
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,773
Thanks: 93
Thanked 1,729 Times in 1,600 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

First, I would be leery of this. Access normally uses SMB (Server Message Block) protocol to talk to its component files. However, OneDrive does not normally work this way. It uses HTTP or HTTPS and talks to a synchronizer app. (See 1st link.)

https://www.netfort.com/blog/monitor...drive-traffic/

I am thinking that this would lead to some serious corruption issues because of file locking conflicts. SMB lock patterns are not exactly the same as HTTP-family lock patterns because of differences in how they address the data-in-motion. However, I can only state doubts, not certainties, on the issues involved.

I know that if you are planning a true OneDrive app, you have to consider that you will have a "sync" app running in the background and you have to consider your network load is going to be very "bursty" when updates are running. (See 2nd link.)

https://docs.microsoft.com/en-us/one...ation-planning

I'm not going to say that this won't work, but if there is even a slight flaw in the way the sync app decides to re-sync, you would end up transmitting a huge file over your network almost continuously. You might see bottle-necked data flow. There are whole forums where folks have complained about slow syncing and getting "hung" while waiting for the files in question to unlock. Search a bit more in the one-drive forum and in the Microsoft support site for topic OneDrive (as one word).

https://support.office.com/en-us/art...c-2b45533edccd

https://onedrive.uservoice.com/forum...parts-of-the-f
__________________
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
Old 11-10-2019, 09:19 PM   #10
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,461 Times in 1,442 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
Thanks for your help theDBguy
Hi. You're welcome. 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 online now   Reply With Quote
Old 11-11-2019, 12:01 AM   #11
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 218
Thanks: 40
Thanked 5 Times in 5 Posts
gstylianou is on a distinguished road
Re: Moving Access Database to OneDrive

Quote:
Originally Posted by DatabaseTash View Post
I have an access database which is currently on our server and is used by about 18 people. The database is set with permissions and a auto-updating utility. Everyone except me uses a read only permission. The Database is a reference for plans and provides a link to the digital copy of each plan.

Management would like to move it to OneDrive. I have concerns with this though. Is it possible? Will it sync properly? Would I move the front and back end to OneDrive?

I also have a PowerShell script I run to insert the hyperlinks when new batches of plans are added. I was told that to run this script everyone needs to be out of the database. Will it still appear with the lock to show if someone is in the database when it is in OneDrive?

Does anyone have any experience with this? The database works like a dream now and I don't want it to be out of action.

HI, its is really bad idea for multi use (18 person).! Since many years i made some testing and always i have many - many problems for multi use purposes. You always have the problem "Conflicted copy" and you will loose data..
gstylianou is offline   Reply With Quote
The Following User Says Thank You to gstylianou For This Useful Post:
DatabaseTash (11-11-2019)
Old 11-11-2019, 01:13 AM   #12
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,350
Thanks: 40
Thanked 3,671 Times in 3,539 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Moving Access Database to OneDrive

Curious as to why management would want to move it to onedrive. If working well now, what would be the perceived benefit?
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 11-11-2019, 01:29 AM   #13
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,380
Thanks: 115
Thanked 3,112 Times in 2,830 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 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.
Yup. This comes up repeatedly and the answers are always the same - don't do it!
For example, see https://www.access-programmers.co.uk...light=OneDrive
__________________
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)
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
DatabaseTash (11-11-2019)
Old 11-11-2019, 03:37 AM   #14
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,829
Thanks: 56
Thanked 1,032 Times in 998 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Moving Access Database to OneDrive

I think management would be interested if it worked, because an off site user could then connect to the one-drive, rather than need to connect to an office based terminal server.

The point that has been made is that these cloud solutions (one-drive, dropbox etc) work by synching local files to the cloud, and because of that aren't suitable for multi users.

I believe Sage have a workround for this problem with their (non-access based) accounts systems, but I am not sure what limits are placed on their "multi-user" cloud version.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
The Following User Says Thank You to gemma-the-husky For This Useful Post:
DatabaseTash (11-11-2019)
Old 11-11-2019, 02:26 PM   #15
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 CJ_London View Post
Curious as to why management would want to move it to onedrive. If working well now, what would be the perceived benefit?
They would like to work towards having everything cloud based and no server.

DatabaseTash is offline   Reply With Quote
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 12:46 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