I work for a non-profit with 2 staff. I live in a part of Canada that is backwards technologically - MailMerge is regarded as the pinnacle of achievement here. I have developed an Access database with a back end in Dropbox, which worked really well when no-one used the program ;). Now they like it and want to use it, which of course DropBox hates. It produces a lot of conflicted files, losing data like crazy. I did research initially and knew DropBox was not a real solution but went ahead since I was not sure they would want to invest further after this preliminary phase was finished. Turns out they do!
I have a degree in Computer Science & lots of database development experience but have no clue at all about servers or networks. My employers have very little money. Here is the hardware situation.
Four fairly new laptops access the database.. three in the office and mine remotely. The institution has decent wifi from a router on site & repeaters through the building. There is one older (but functional) laptop and one pretty good desktop available to be used as servers.
Can Windows Network work for this? File sharing? The Board might be willing to spend up to $800 at most. I volunteer a lot of time and think I can probably figure out how to implement your suggestions, but right now am at a loss as to how to proceed.
Any and all suggestions most welcome. Thanks!