Hi,
I have a database with linked SharePoint lists.
One of my datasheets running on a query will not filter properly.
Instead of getting the drop-down list with the available choices, I get an option to ENTER the filter item. When I enter the filter item, I get an Error.
After trying to troubleshoot this for some time, I decided to see if it would work properly if I made a copy of the db and made the tables Local. It works fine.
Here are some screenshots (I apologize for the messy blocking of the data):
DB with linked SharePoint lists 1
DB with linked SharePoint lists 2
DB with linked SharePoint lists 3
Same DB with Local tables
Does anyone have a solution for this? Is there any better way to make an Access database available to multiple locations, other than linking to SharePoint lists?