I've attempted for days now to create some mechanism in the MS SharePoint MS Access 2010 ecosystem that will enable the use of either:
- create SP List, import a link to the SP list into the Access Web Database; or
- create Access table, create a web part that will display table data.
What am I attempting to achieve?
I want to be able to enter user data (separate from default Users) once into either the Access web database or once into the SP list, and have that same data accessible by the other...
I've attempted a number of options but so far can only seem to:
- create a hyperlink in a web page that links directly to a table in the Access web database, however I want a "view" not a link;
- link an SP list into the Access web database, however cannot use those list links in lookup / relationship fields in other web database tables.
Maybe this is a limitation of the software?
Any assistance gratefully appreciated.
