So In the past I have used Access Web Apps on SharePoint to act as a database to store the data related to all of the CAD workstations for my company. With the Access App, I was able to track workstations, who the workstations were assigned to, as well as keep track of the workstations age for replacement purposes. This made it easy to run reports every quarter to determine which workstations were up for replacement.
I have recently tried to create another one of these Access Apps for a similar situation and I ran into a problem. When trying to create the app, I received a message that said,
"Sorry, your company administrator has restricted creating new Access apps. For more information, see the Access Services in SharePoint Roadmap at https://go.microsoft.com/fwlink/?linkid=847798"
After further reading, I discovered that Microsoft, "no longer recommend Access Services for new web apps and web databases"
The reading goes on to say that the feature will be retired from Office 365 and SharePoint Online starting June, 2017 and shut down any remaining web apps and web databases by April 2018
It suggest using PowerApps but I don't think this is a viable option.
Specifications of the Access Web App
As mentioned above the database is used to store information regarding CAD workstations at my company Within the Access App I have three tables
The Computers table stores the information regarding the workstations: computer name, user assigned to that workstation, acquired date, replacement date, make, model, status
Locations table stores the location information for our various R&D sites and offices around the world: city, state, country, country code
Users table stores the users information: name, userID, location, email, manager, R&D group
Since I can no longer use Access, what are some of my options for creating a similar system that integrates with SharePoint??
I liked the interface of the Access App because I could give the various R&D group managers access the the App and they could easily run reports for the groups they managed for budgeting purposes, without it being to complicated for them.
I realize that the general data storage can be done with SharePoint List; however, I was wondering if I could get the same look, feel, and functionality with SharePoint as I do with Access, such as pop-up that allow you to add new entries without leaving the current list and run reports based on specific criteria (location, retired assets, ect.)
I'm up for anything and and suggestions are encouraged