Search results

Thank you for that Pat and noted your comments on SharePoint, OneDrive and cloud generally as a places not suitable for an Access database that will be used by multiple Users simultaneously. I wanted to clarify, the application is an Excel front-end with an Access database back-end. Originally...

It would be for transactional data - initially several hundred rows. But eventually, the application could extend to other 'mass data' which could easily be hundreds of thousands of rows. What is the limit on SharePoint rows?

Thanks Isaac. To answer my own question , I think SharePoint is basically a web-page + file sever of sorts. It cannot house an instance of SQL Server.

Thank you guys for your responses. I'm sorry I was unclear. I have an VBA Excel spreadsheet that connects to a single central back-end Access database. All the data for the spreadsheet is stored in the Access database. The front-end spreadsheet stores no data and contains the VBA code. It is...

SharePoint and databases CONTEXT: We currently use an Excel spreadsheet application that connects to an Access Database through VBA using ADO. Separately, we are licensed for O365 and have SharePoint. We can log into our SharePoint via web remotely (ie, from home). There is a requirement for...