Maybe completely irrelevant, and certainly shows my level of experience
but - something I only found out today:
DAO recognises '*' as a wildcard.
ADO recognises '%' as a wildcard.
So, if you've built up your SQL string in Access (which uses DAO) and then stick it in your ASP page (which talks to Access via ADO), you'll get all sorts of amusing errors which will keep you entertained for hours until you decide that Thursdays were never a good day anyway, and you'd be much better off in the pub.