As you have discovered, you cannot use a SQL statement to insert files into an Attachment field in an Access database. You have to use the LoadFromFile() method of an ACE DAO Field2 object. The following C# code works for me. It is adapted from the Office Blog entry here. using System; using System.Collections.Generic; using … Read more
Try changing LIKE to ALIKE and your wildcard characters from * to %. The Access Database Engine (Jet, ACE, whatever) has two ANSI Query Modes which each use different wildcard characters for LIKE: ANSI-89 Query Mode uses * ANSI-92 Query Mode uses % OLE DB always uses ANSI-92 Query Mode. DAO always uses ANSI-89 Query … Read more
The Problem is that OleDb (and Odbc too) does not support named parameters. It only supports what’s called positional parameters. In other words: The name you give a parameter when adding it to the commands parameters list does not matter. It’s only used internally by the OleDbCommand class so it can distinguish and reference the … Read more