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

Click image for larger version. 

Name:	Screenshot SP1.png 
Views:	9 
Size:	209.6 KB 
ID:	23084

DB with linked SharePoint lists 2

Click image for larger version. 

Name:	Screenshot SP2.png 
Views:	9 
Size:	198.1 KB 
ID:	23085

DB with linked SharePoint lists 3

Click image for larger version. 

Name:	Screenshot SP3.png 
Views:	9 
Size:	195.9 KB 
ID:	23086

Same DB with Local tables

Click image for larger version. 

Name:	Screenshot Local2.png 
Views:	9 
Size:	150.8 KB 
ID:	23090

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?