Sharing Access from one machine to other machines via OneDrive

[jun11dags]

Hi All,

I'm a newbie with access and we have a requirement to setup an Access in 1 machine and have it be accessed by others users/machine. The thing is we are neither allowed for remote desktop or such nor having a sharepoint. The only means of communication between these machines is via OneDrive. My question is, Is this possible and any idea how can be done? I am thinking that it should be possible especially both microsoft product.

Thank you in advance. Cheers.

 

[mole999]

can you set up a network, install the backend on a server and everybody has a front end

 

[jun11dags]

Unfortunately can not.

Originally that is the setup, but the client removed all shared folder/repositories/servers and instead just want to fully use OneDrive.

As what I read, Onedrive does not support dynamic MS Access. So what I'm thinking is maybe to let other users share in the OneDrive folder their own accdb(with their own updates) and from the machine where the main accdb is located will do a merging then share again the updated accdb. Although I think this is a bad approach.

 

[mole999]

sounds bad to me, maybe the client needs to invest in a network person to establish a safe methodology, the give it back to the users with paid support

 

[alansidman]

Read this link to understand why this is not a good idea and the restrictions it imposes.

Access 2013 split database with backend on One Drive - Microsoft Community