Discussion on:
Message 4 of 17
Azure and Sharepoint and 365
Like I said, I am a pretty small time programmer that got into VB and Access years ago to simply create a plant specific application to unburden me from all the compliance and monitoring reports for the EPA and to track all the process control parameters to make sure everything running well. I run a small water plant and a wastewater plant. Over the years I have made it generic enough that can be configured easily for other small plants. And it would be very useful for operators at similar plants (and of course there are thousands of them). Access has evolved to the point now it can handle just about anything I need for it to handle. I have for example a table with over ?? million records and can query and filter very quickly. What I am particularly intrigued with in Office 365 is to be able to put those tables and certain forms in the cloud where the data is accessible anywhere and with permissions, etc. and can be easily updated or viewed. Then when want to do more cpu intensive functions such as running complex queries, reports, etc. or view more complex coded forms, one can simply open in desktop Access and run those on the client. Best of both worlds in many ways as changes made when offline on client are automatically synced with the cloud, and any data entry done on cloud forms automatically synced with desktop every time it is opened. But the real beauty is that easy to distribute and update to any user around the world. And you get this for $6.00 a month. If someone wants a change, for example, I only have to log onto their SharePoint account, open the database in my desktop version of Access, make changes, upload it back, and the next time they open it up, the changes are there. Almost as easy as having updates to a mobile app be installed. For certain apps you could as I probably intend to do, simply include the Office 365 account for three months or a year or whatever already configured. I honestly think possibilities are pretty large for this kind of thing. This is of course not to say that I will ever get around to doing all of this, as I have all these software companies and IT departments wanting my engraved bricks and minifigs, but it is I think a very good model of how to distribute customized software for specific applications. Not all cloud apps need to be accessed by hundreds of concurrent users. Mineral collections, coin collections, all kinds of research projects, etc. etc. etc. Possibilities really are pretty endless.
Posted by brickengraver
23rd May

































