I'm using WSS to link to a SharePoint list in Access. My problem is that when linked, only 1 item is coming though--I think this is because the default view for the list has a filter: "Created By = [Me]"
My fix for this in the past has been to create a Personal View called "(Export)", and in this view not use that filter. However in my current implementation I need other users to run the Access database and I don't want to encumber them with a "(Export)" view--and I also don't want them to be able to see other people's records through the interface.
The "(Export)" view has been linked by this command:
DoCmd.TransferDatabase acLink, "WSS", "WSS;DATABASE=http://<SERVER>:<PORT>; LIST={<SOME GUID>}; VIEW={<SOME OTHER GUID>}; RetrieveIds=Yes; ;TABLE=My List: (Export)", acTable, , "lnkMyList_Export"
This command doesn't work for my other users because "My List: (Export)" is a Personal View.
For the solution, so far I have this:
DoCmd.TransferDatabase acLink, "WSS", "WSS;DATABASE=http://<SERVER>:<PORT>; LIST={<SOME GUID>}; RetrieveIds=Yes;", acTable, , "lnkMyList_All"
However that--and everyother connection string hack I've tried--only yields the one entry.
Any help would be very grately appreciated. Thanks.