> Does Access have different SQL syntax than SQL Server? Yes, there are some minor differences. Which is really annoying since they're both Microsoft products. I'd give you some examples, but I'd hate to get them wrong (I always have to use trial and error).
Scott ---------------------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists