Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Wildcard Filters not working with MS Access Linked Tables

...

To solve this problem you have to use the % (percent) character instead of the * (asterisk) for the wildcard in your query criteria i.e.

...

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel in ( "data" , "loader" , "dataloader" , "ms" , "Microsoft" , "Access" , "query" , "wildcard" , "filter" , "linked" , "tables" , "troubleshoot" , "trouble" ) AND label != "excel" and title ~ "-\"Troubleshoot MS Access query problems\""