Remember Microsoft Access? Some of you do. Some people still use the desktop side forms and creating product databases. Way back when, before SharePoint, I remember how to use Microsoft Access to a variety of things to asset management, helpdesk deforestation, managing small businesses. Some of my creations has become quite complex. Access provided a way for anyone to generate forms of front-end for storing data in a proprietary database.
One of the biggest drawbacks was the sharing of the database that the computer shuts down (or crashes) before closing the connection to the database from corrupt Access database would in a heartbeat. I spent many afternoons and evenings restore the database access and, in some cases, having to re-create the lost or damaged data. At first I thought I had good memories of the product, but now, in retrospect, it was more trouble than it was worth. In the end, Microsoft has developed some utilities to convert soft enough to migrate Access database to SQL Server, so there was less concern about loss of information or dealing with corrupted data.
Based on past wrongs, it’s interesting to me that Microsoft Access is still around, especially as an offering to Office 365, but Microsoft just announced that access (called Access applications) came out in the preview is now available for production environments. Access applications have been in preview for a whole year, since Office 365 was publicly released in February 2013.
Access to Office 365 has evolved such that the owner of a database is no longer needed. Access is now just a web form design and data are stored directly in SQL Server or SQL Azure. This also means that access applications can also share the data stored in SharePoint 2013, Office 365 Office 365 Small Business and Enterprise.