access apps on sharepoint

pma111 used Ask the Experts™
has anyone every attempted to store an access application in a document management system such as sharepoint? My initial reaction was 'that would never work', but our IT are trying to migrate data from  traditional file servers to sharepoint, but I wanted some insight into will an access application ever work in a system like sharepoint, or access databases accessed by numerous staff work in general? I am hoping the answer is no so I can suggest it isnt worth even investigating.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
It will/may only work for storage, like backup of the file.

For operation, Access needs an SMB file share - like a normal Windows Server or a Linux share with Samba - and neither Sharepoint nor OneDrive is that.
Most Valuable Expert 2012
Top Expert 2014

You can design Access systems that store data on Sharepoint lists, but that's about the extent of it (and most experienced Access devs will advise you to stay far, far away from that scenario).

But as Gustav said, you can't run an Access app from a Sharepoint location. You'd have to download the "document" (the Access app) and run it locally.
Distinguished Expert 2017
To continue Scott's last sentence.

And if you dowload the Access app to work with it, userA's changes will overlay userB's changes if they happen to be working concurrently since there is no file sharing going on.  Each user has control of the file separately and his updates replace the previous updates when he puts it back to the server.

There are other options.  Citrix is probably the best if you need remote access to a multi-user Access app.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial