I'm desperately trying to link to a sharepoint view, not the allItems because my link fails. I have too many "lookup" fields in sharepoint (more than 12). So restrict my view. I had hoped this limit wouldn't apply to my list when linking, but it does.



So I attempted to link to a specific view, and it doesn't work - it tries to pull in the entire list. If I use "import" I can select from a pulldown which view, but I don't want to have to re-import every time the Access tool is used.

What am I missing? I googled, I see instructions that match what I am doing for linking, but no pull down for the view exists. Only when I select "import".