Well, that puts you in a challenging place. ActiveX is dead so no need to pursue that path. MS Access and VBA are close to dead. I am not familiar enough with your needs to recommend an overall architecture. However...
Look at Microsoft PowerApps. That would probably be the best tech I can think of for what you are facing. Connect the data to a SAS dataset using the SAS OleDb/ODBC driver. Barring that, use something like Sqlite to house the data so it is standalone.
FYI, I am writing a SAS dataset to Sqlite converter right now but it won't be ready for primetime for a week or so. Once it looks good, I will put in on github.
You are welcome to reach out and ask questions. Unfortunately, you have an XY Problem that is hard to answer remotely.
... View more