none
Can Access 2013 be run from SharePoint as a regular Access database? RRS feed

  • Question

  • I have a user who put their Access 2013 database on SharePoint 2013. It is NOT an Access web app. Can you run a regular Access database from SharePoint?
    Tuesday, August 16, 2016 9:16 PM

Answers

  • No.

    SP is a repository for files, not a good home for an active Access application. Store the BE on some file server in the file system, and the FE on each workstation. Any other configuration is asking for trouble.


    -Tom. Microsoft Access MVP

    Wednesday, August 17, 2016 12:29 AM
  • I concur completely with Tom.  The back-end needs to be housed on a proper LAN file server to avoid problems (performance, corruptions, ...).  I would ask them to change their setup or switch to use a Web App utilizing SharePoint as the BE. 

    That being said, Web Apps are deprecated and were replace in 2013 with Web Databases which utilize Azure as the BE which is far superior, so I personally would invest any time in a Web App. Keep in mind Web Apps/Databases do not support VBA, reporting, ... so have limited usage scenarios.


    Daniel Pineault, 2010-2012 Microsoft MVP
    http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Wednesday, August 17, 2016 12:43 AM

All replies

  • No.

    SP is a repository for files, not a good home for an active Access application. Store the BE on some file server in the file system, and the FE on each workstation. Any other configuration is asking for trouble.


    -Tom. Microsoft Access MVP

    Wednesday, August 17, 2016 12:29 AM
  • I concur completely with Tom.  The back-end needs to be housed on a proper LAN file server to avoid problems (performance, corruptions, ...).  I would ask them to change their setup or switch to use a Web App utilizing SharePoint as the BE. 

    That being said, Web Apps are deprecated and were replace in 2013 with Web Databases which utilize Azure as the BE which is far superior, so I personally would invest any time in a Web App. Keep in mind Web Apps/Databases do not support VBA, reporting, ... so have limited usage scenarios.


    Daniel Pineault, 2010-2012 Microsoft MVP
    http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Wednesday, August 17, 2016 12:43 AM