i have a simple (MS Access) table with about 20 data fields.columns, and less that 10 million rows of SAP user security data. Under one of the audit policies, I need to periodically present this data to the designated data owners, and need to capture their input as to the changes & additions to this data. Based on the data owner's input, I engage the SAP Security team to implement the changes within SAP user roles, etc, and then repeat the same process next quarter/period. I do need to maintain the history of all changes (only) made by the data owners for tracking purposes.
I have the process working in MS Access 2016, however, I am asked to move the process to our SharePoint. That is where my problem begins, and I have the following questions/issues:
1- Is SharePoint capable of handling this kind of project. My initial concerns are the # of rows in the table (10 M), & the # of rows of data being displayed or returned from a query for display, which is limited to 5,000 rows. Is that true?
2- AT the moment, I am using VBA to do most of the back-end processing required to maintain the history of changes, replication of tables, etc. and do not know, how to accomplish that in SharePoint? In other words, how, with which tools, I can replace my VBA code with, in the SharePoint?
3- If SharePoint is not my solution, what would be the best fit for replacing my MS Access solution that is web based, with robust data security features?