I am involved in a small project with a local sporting club to digitise it’s playing records.
The club has scorebooks going back to the 1930s in it’s storeroom where they are OK but still vulnerable to fire, vermin, and other paper destruction vectors, so it’s preserving that history.
Anyhow, we have a couple of collators who are transcribing the books into Excel templates ('cause that’s near universal in availability and user familiarity) which they send to me and I then aggregate and consolidate them into a MS Access (2016) database. It comprises three related data tables imported from Excel and an interface only of series of reports or forms. There is no data entry or transactions within the application. Just straight forward enquiries/extracts of the “show me all the guys who did [this] in [this] season and [this] grade” ilk.
Eventually the results will go into the national web-based and supported application we use for all the current grade fixtures played since 2008 but that could be some time away.
All is going well, we are now into the games played in the 1960s and within living memory. It’s time to show others our progress.
Now the original plan was that there’d be a couple of meetings and I’d run a demonstration off my laptop and let the club directors and committee each have a play. Not a problem. But Sydney is in COVID-19 lockdown. The app is only a couple of dozen MB so I could distribute by email, thumb drive or use something like DropBox but none of the target audience have MS Access.
Yes, I can do a Zoom and share my screen which might be the most practical option but I’d like the directors to get their own hands on the application. For some of these guys it will be the first time they have seen their own playing records for 40 years. A chance to quietly revive memories of past glories.
So I’d like to deploy something like a standalone version
Now based on my Googling the answer on how best to do this ranges from:
- It can’t be done.
- Convince them they need a MS Access license
- It can be done with Runtime
- There are utilities to compile standalone executable MS Access applications.
Can anybody advise if they have any similar experience and what solution they found worked best?