Solved

Access backend on SharePoint library

Posted on 2015-02-11
3
303 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 51

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 51

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

Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Suggested Courses

615 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