I guess I’m looking for some general advice for if what I’m wanting to do sounds at all sensible. I’ve done my fair share of Python and Rhinoscript stuff, but more general business application concerns are not my thing…
So I made up a little Access database that I’ve been using to track product specs and such for a client. I’m looking to automate feeding the data for products from Rhino in to it, and then out to InDesign documents for publishing, just generally expand what it can do. I also want to migrate the database online so that other people can access it, whether they’re adding new products through Rhino like I am or some basic read-only role. We’re all on Teams, BTW.
So my research has found that there’s this new-wish Microsoft thing called Dataverse that’s almost tailor-made for the migrating-Access-online purpose. So my plan is to migrate the tables there, then use (this sounds SO archaic?!?) VBA in Access as the main coding solution to make the database talk to Rhino and InDesign. Last year I tried connecting to the Access database through Rhino Python–I tend to do everything through Rhino whether it really involves it or not!–and that was just fifteen kinds of hassle, trying to get the Access 64-bit odbc driver working HOSED MY WINDOWS INSTALL.
Others who don’t need to do all that work can access the data through a cut-down Access front-end or maybe I’ll even use Power Apps for that. Does this sound like a bad idea, or the worst idea ever?