Wildcard Query on an Attached Sharepoint List - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Wildcard Query on an Attached Sharepoint List

Robert Kaplan

9 months ago

Hello !

I have attached a Microsoft SharePoint list to MS Access.

I'm able to successfully query the SharePoint list using plain vanilla MS Access queries and queries that use "full" parameters - however I cannot successfully run queries against the attached SharePoint list when I use a wildcard (e.g. *) in my parameter.

It seems like it should be a simple thing to do!
Has anyone else been able to do this?

Thank you!
Bob

	John Campbell @Reply 9 months ago
What is your wildcard statement you are using in the query?

	Richard Rost @Reply 8 months ago
Yeah, let's see a sample of what you got going on there. You don't have to use the SQL Server syntax and wildcards with SharePoint unless you're using a pass-through query. That's tricky. Let's see what you got.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View