Hi Ted,
<<We have an odd problem with CRecordset::m_strFilter. We have an Access
database Table with a column labeled "Location" which is an indexed field
(CString type). When we issue a Open request with m_strFilter set to
"Location = OverThere" we get the following database exception message thrown
…
Error in expression.
'OverThere'
Invalid column name: 'OverThere'
>>
The syntax for the m_strFilter string should be:
m_strFilter = "Location = 'OverThere'";
Steve Roeder
Microsoft Developers Support