[mdb-dev] An Example SQL

[Adam W. <awi...@wh...>]

I'm in the process of updating my Data Access presentation for a
re-showing in a couple of weeks.  So I'm testing the current version of
MDB Tools.

Unfortunately I can't get an SQL with a where clause to execute.

"select * from employees" works.

but "select * from employees where city = 'Haslett'" returns nothing. 
It shoudl return several rows.  And "select * from Employees where
Active = 1" returns every row, even where active = 0.

Maybe I'm missing some sytax quirck?