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
LVL 4
Keyboard CowboyAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
That seems not to be doable under the current restrictions.

You will need an SQL Server database as backend.

/gustav
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.