|Be careful, as Jeff suggested use the ISO date format of YYYY-MM-DD becuase if its run on a machine with different regional settings you may get caught out. If you use the ISO with the year leading in, Access recongnises this correctly. 11/12/03 can be interpeted as Nov 12 on a US machine, but on a UK machine its Dec 11.
Yes for dates you are supposed to use # instead of ' with Access. You can see the query builder add them in for you in Access.
"Je pense, donc je mange." - Rene Descartes 1689 - Just before his mother put his tea on the table.
Shameless Plug - Distributed Database Transactions in .NET using COM+