Best way how to share an Access database including forms, queries, etc.

[MichaelaW]

Hi there.
I have an Acess database (2013). This will be used by several people within one company, they don't have their own server. I would use SharePoint Online, but it seems to me, that you only can "export" the tables.
The database I have is quite a complicated system, and it is neccessary to use all the Access tools - forms, reports, queries. Not tables only.

Another idea is to split the database and "store" the backend part (the tables) on Sharepoint (Office 365 online version). And all the users would have their own frontend (forms, queries...) on their own PC, linked to this backend.
Would this work? Can everyone add some entries into the database this way? How does it "synchronize" then?



Thanks a lot for any answer.

[ranman256]

Usu., all the users would have their own frontend (forms, queries...) on their own PC, linked to the 1 backend.
Its how I give it to users. They also get a new FE version when revisions are made.
BUT , Ive never used sharepoint for the BE. I would guess it works the same if you have the passwords.