I have just got my application up and running and connected to an access database and now I've started playing with the SQL a bit. Using a class derived from CRecordset in the MFC I have overridden getDefaultSQL to return the string "select * from competitors". This works fine, although when I try to add a where clause in the SQL it crashes at runtime and I dont know why. I have been trying SQL strings such as "select * from competitors where age < 18" but this doesn't seem to be working.
Any advice is welcome, or if not it'd be great if someone could direct me to a helpful website