Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

Access backend on SharePoint library

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
Keyboard Cowboy
Asked:
Keyboard Cowboy
  • 2
1 Solution
 
Gustav BrockCIOCommented:
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
 
Keyboard CowboyAuthor Commented:
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
 
Gustav BrockCIOCommented:
That seems not to be doable under the current restrictions.

You will need an SQL Server database as backend.

/gustav
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now