I have a client who as part of a larger project wants a fairly standard Management Information System Database. It will contain the standard tables (Client details, orders, products) and will be mainly queried for the 'which postcode buys most of product X' - 'what were the geoggraphics of sales on April 8th'. So nothing exceptional and nothing to difficult.
They have an office with 4 pc's networked and a laptop. My initial thoughts were for a simple MS Access database on the network but during discussions the possibility came up of them using the database when on the road at shows etc. This lead me to wonder if a remote server with 'mySQL??' would be a better option.
My question is what are the benefits and disadvantages between the local and remote options?