10

A SharePoint list that can be edited by both MS Access desktop and MS Access web apps (Access 2013).

I want a SharePoint list that works offline and then syncs when the network is working.

Sorry, I have tried several things but getting nowhere. I am new to using SharePoint, but have spent years creating databases/software.

Things I have tried, and failed:

  • creating tables offline then uploading as a linked SharePoint list. It uploads but then the web app only has read access.
  • creating a web app, adding a list. But then the desktop application is unable to see the table.
  • Creating an Access 2013 desktop application. Create a linked SharePoint list from the application. But the web app only has read access.

Edit: It says 'Read only' when I link a SharePoint list to a web app. i.e when I use Access 2013 to create a web app, at the point when I link the SharePoint list, it only gives me the option of a read only style link.

  • Which version of sharepoint are you using? – Taran Goel Jul 8 '15 at 6:27
  • The Sharepoint is Office 365 - MS hosted. (I assume you mean MS hosted sharepoint vs a local server, or is there another kind?) – eddyparkinson Jul 8 '15 at 7:48
  • how many users (approx.) are connecting to this app? – jpollar Jul 17 '15 at 15:10
  • Instead of trying to use different Models in a MVC solution, try moving your data connection to the controller. Both access and Web App should be able to use web services to make the calls. Build and deploy the list as your model, them use SharePoint Web Services as your view and use your app and access as your controller. Instead of using the built-in SP interface of Access, switch to use web services as a consumer and you will get there. If you want a demo, I will need some specific info about the composition of your data and versions of your apps. – ghangas Jul 20 '15 at 21:32
  • @jpollar About 5-25 users. At the moment there is not much point for local hosting of share point. But longer term it could be an option. – eddyparkinson Jul 21 '15 at 2:58
1

If you have a list in SP you could use the function to open list with AccessOpen With Access on the SP List Ribbon

When you do this it will ask you if you want to save your new access file to the SP server (answer yes and you have your linked Access file). This could be opened by access web services or access client. You could use that file to build all your forms in. This could be a workable solution if you want to link permanently to one list.

I think that there are some decent syncing options already built in to this solution. However, I am not entirely certain that this would fly in o365 and what all you want in your DB.

  • Your image with the "Open with Access" button. What tool is it, is it desktop or web based? – eddyparkinson Dec 17 '15 at 0:42
  • That was lighting up because it recognized my desktop one. However, one you open it using the desktop version, then you save the .accdb file to SharePoint and you will have the connected DB published to SP able to run in access services and desktop. – ghangas Dec 17 '15 at 21:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.