our current remote view uses a Transoft C-ISAM ODBC driver that according to MS does not even comply with ODBC level 1 standards....but it works with select statements like: SELECT * FROM dbo_WipMaster WHERE dbo_WipMaster.Job = ?cJob however, the new SQL MS driver says invalid column 'job' when using the conditional WHERE clause. If we drop the WHERE it pulls the entire table in just fine.