@dashrender said in Need MS Access app re-written to something else.:
@scottalanmiller said in Need MS Access app re-written to something else.:
@dashrender said in Need MS Access app re-written to something else.:
While I think Scott's a bit overblown with the whole Windows Server and SQL server to be "serious" I see where he's coming from.
For example sticking with Windows 10 for example is likely fine because I'm assuming it's being run on and from a single machine connected to the gate system, not a remote server, etc...
It's a licensing requirement if you want security and reliable multi-user access. Otherwise you have to use the shared-file system of a JetDB that is completely exposed to things like ransomware. And that is highly flaky once you have more than about five users.
This really seems like a single computer setup - so while what you mention could be good, might be overkill for this setup.
It is a Raspberry Pi setup, IMO. I think @JasGot is right on that.
I think he is off on the "wishing he had 5 hours" thing though.
I don't know enough about controlling Pi pins to handle this. I think that would be better than the serial interface for the relay control. But it will also require then new wiring which is physical.
The barcode readers should be a standard listen for input handler.
The database design should be pretty straightforward.
The user interface does not sound like it needs to be complex, but like anything, you need to make it comfortably usable, or users will not use.
Finally, security of the application, it's users, data, etc will have to be designed.