Problem with Microsoft.JET.OLEDB.4.0 using Access 2000 MDB file, queries over MEMO field type aren't working. RRS feed

  • Question

  • Hi,

    I'm using OleDbConnection along with OleDbDataAdapter to get results from an old Access 2000 mdb file.

    I have a problem with this query:

    Select count(*) from sometable Where [memo field] like '*FOO*'

    If I execute such query from Access itself, it gets a counter greater than 0.

    If I execute same query from C# using OleDbDataAdapter (using the Fill method), I got always zero.

    Has Microsoft.JET.OLEDB.4.0 some limitations that Access itself hasn't with memo fields?


    • Edited by souliaq Thursday, March 29, 2018 4:33 PM inaccuracy
    Thursday, March 29, 2018 4:01 PM