Question Ways to share Access database on company intranet?

[DavidA2015]

Hi

I am a new member on this forum. I am an experienced software developer but I don't know much about Access.

I want to consider ways of sharing an Access database within our company. This could be web-based via our intranet or done some other way.

I understand that Microsoft's preferred way of sharing via an Intranet is to use SharePoint. However, as we don't use SharePoint (we use Atlassian Confluence) the cost of that route would be prohibitive.

Please will you suggest the recommended methods of sharing an Access database across, say, 20 people? Simultaneous read/write access would be required but in reality the usage will be low, so performance is not really an issue. I would like to consider web-based or other methods.

I have chosen Access 2013 simply because we use Office Professional 2013 and Access will be familiar to some developers. We could use a different product. But I would certainly prefer a tool that supports RAD design of forms.

Best regards

David

 

[spikepl]

For WAN access to Access: http://www.access-programmers.co.uk/forums/showthread.php?t=241257

So long as all are on the same LAN then the standard setup will do: frontend DB local for each user, backend with data shared by all in some common location. For occasional external access you then can use remote desktop tools.: Windows RDP or VLC or that ilk.

Design with eventual upgrade of backend to SQL server (free express version) in mind. SQL server can alleviate network congestion issues (if appearing), because on occasion Access can need to drag a lot of data across the network, if the backend also is an Access db. In any case, hopefully you have a 1 Gb network.