Using oneDrive to hold split database access by local PC (1 Viewer)

[FuzMic]

Guys
Just wonder if anyone has tried putting a split database in OneDrive & mapped it as a Netdrive in a PC for msaccess Front end to access. .pros & cons ?

 

[gemma-the-husky]

You might be able to use it for a single user database accessed from multiple locations.

The trouble is you actually work on a local copy, and then windows synchronises your local copy with the cloud copy. So you can't have multiple concurrent users.

 

[isladogs]

You shouldn't run any database from a cloud storage such as OneDrive or Dropbox.
It will significantly increase the risk of corruption whenever there is a brief interruption in the online connection.
Don't do it. Not for FE or BE

 

[FuzMic]

Oh!

 

[isladogs]

Cloud storage is perfectly OK to save backup copies or distribute databases.
However, they should NEVER be run from cloud locations.
The problem comes when any data is being written and a brief internet outage occurs.

Even a split second break can cause corruption

 

[The_Doc_Man]

@FuzMic - the problem is that cloud storage uses whole-file transfer protocols, but Access derives its sharing from the Windows File and Printer Sharing protocol called Server Message Block (SMB) - which is a way to share a PART of a file. Cloud servers almost NEVER recognize SMB requests coming in. However, the specific danger is that even if they DO recognize a partial-file request, the cloud connections tend to be unstable. If you were writing back a part of a file to a cloud file and the connection broke, what do you think would happen to that partially updated Access file? (That was a rhetorical question... answer: It would become corrupted and unusable.)

I suppose you COULD try it - but the risk factors lean VERY HEAVILY towards corruption - within a matter of hours or days.

 

[Pat Hartman]

Now that we've convinced you that Cloud storage isn't your solution, there are options if we know what problem you're trying to solve. My clients use Citrix or Remote Desktop.