access apps on sharepoint

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.
LVL 4
pma111Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
PatHartmanCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Document Management

From novice to tech pro — start learning today.