We are looking to set up a database (using Microsoft Access) that can be accessed by several other organisations of whom we have shared clients. It doesnt need to be anything flash as it is just for entering basic data, if there was some ability to attached files like PDF's etc. would be good but not essential.
The way I am planning to do it is just create an access database and host it on a dedicated computer and give everyone necessary access to the computer through RDP to enter/access data.
How does this sound to everyone? it is probably a pretty crude way to do it but can't think of a more effective way, anyone have some better suggestions?