We have 4 MS Access databases and we need to locate these in a central location from where 8-12 users can access, edit and co-author these databases.
The most important of these databases contain sales and order information and at busy periods we require that users can simultaneously edit and update the databases in realtime.
We are currently trialling Office 365 and although it's pretty satisfactory, there is no MS Access Web App. Hence we can't edit the databases "on the fly". I have also set up a Cloud Server on which I have installed Sharepoint Server 2010 (30 day evaluation). However, I am still struggling to resolve the issue. It seems that Sharepoint Server gives me the same functionality as Office 365 as far as MS Access is concerned.
Would anyone have a suggestion as to what I could do to solve this problem and, in essence, allow our databases to be accessed and edited simultaneously from a number of different locations.