Syn with Office 365 or Sites

[sajarac]

Hello there, hope any guru can help me!!

I have a MS Access Database, and in our company we have office 365, I would like to share my database which is located in my desktop PC Onedrive folder, with a couple of colleagues, but I want that those guys have the ability to edit or add new records, currently they have a link for the file, have to download the entire file edit and the upload again.

Any way to do this easier?

thanks in advance for any cooperation.

Regards

Sajarac

 

[GinaWhipp]

You can't use One Drive like that. You need to split the file and put the Backend on a Server and distribute Frontends to everyone. Take a look at...

http://www.kallal.ca/Articles/split/index.htm

http://allenbrowne.com/ser-01.html

http://www.utteraccess.com/wiki/index.php/Sharing


You may also want to take a look at MVP Tom Wickerath's article…

http://www.accessmvp.com:80/Twickerath/articles/multiuser.htm


To handle the update of multiple front ends see…

http://www.autofeupdater.com/
http://regina-whipp.com/blog/?p=184
http://www.btabdevelopment.com/ts/freetools


If each user needs Access you can install the Runtime…

Access 2007
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

Access 2010
http://www.microsoft.com/downloads/...cd-5250-4df6-bfd1-6ced700a6715&displaylang=en

Access 2013
http://www.microsoft.com/en-us/download/details.aspx?id=39358

 

[sajarac]

Wow, thank you very much for your prompt reply, this is much information that I was expected.

I will check and keep you posted.

Many many thanks!!!!

Sajarac

 

[GinaWhipp]

Glad to help! Will be here if/should you have more questions...

 

[sajarac]

In fact yes, after read almost all of the articles, still in the limbo. so sorry. I don't get it, no one point exactly how to do it using Onedrive or share point.

 

[GinaWhipp]

You cannot use One Drive so there will be no posts on that. As for SharePoint, well, that's a whole new ball game. However, it is not going to work like... plop database backend and have everyone share frontends, you'll have some work to do.

Is there not a Directory on the Server you could store the Backend?

 

[GinaWhipp]

I found a thread that should shed the light on One Drive or 365...

http://answers.microsoft.com/en-us/...s/6ad7550a-486f-4b17-afdb-1ef1c63e9679?page=2

 

[GinaWhipp]

beveryl,

I am not sure what you are trying to say, please elaborate as I think you missed the point of the initial post.