Solved

Access backend on SharePoint library

Posted on 2015-02-11
3
289 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
  • 2
3 Comments
 
LVL 49

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 49

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

813 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now