You probably have a copy-and-paste error, because even in Access that shouldn't run: you've got an unmatched single quote at the end. You probably meant this:
SELECT * FROM TBLDATA WHERE ([Event Date] LIKE '8/08/2006*');
The question then is, what data type is [Event Date]
? If you're storing the date as a string, then you need to match the string format exactly. Otherwise, if you're storing it as a date, you should be able to do it with the funny Access hash-quotes:
SELECT * FROM TBLDATA WHERE ([Event Date] = #8/08/2006#);
If that doesn't work you may want to try canonical ODBC date format: '2006-aug-08'
. It's hard to say without knowing more about the database and the code.