Solved

Access backend on SharePoint library

Posted on 2015-02-11
3
295 Views
Last Modified: 2015-02-11
I have a need to host Access backend databases on a SharePoint library.   Due to the particular server restrictions I have  - I cannot host the access data directly in a sharepoint list - I cannot host it on a shared drive - the ONLY way I have to share files is via a SharePoint library and I can't use Access Web services on this particular server.  I tried to link to an Access backend from my frontend via table linkage but there doesn't appear to be a way to link to it.  I looked into using WEBDAV services to assign a shared drive letter to the SharePoint library but that is not enabled on my windows configuration.  I have virtually no way to get Access web services turned on and once again, i cannot just upload the data from Access into a SharePoint list (which is what I would do if I could).
ANY ideas on this? thanks so much
0
Comment
Question by:Keyboard Cowboy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40603724
It seems like you will have to copy the file to a local folder and open it from there.
Then, when finished working with it, copy it back.

/gustav
0
 

Author Comment

by:Keyboard Cowboy
ID: 40603886
Thanks - I need over 130 users to be able to update the backend however with about say 20 concurrent users.  
They would all have a copy of the frontend database.
0
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40603997
That seems not to be doable under the current restrictions.

You will need an SQL Server database as backend.

/gustav
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question