> Isn't it impossible to do this when you're using Access? > > I know you shouldn't be using Access, etc., but I've never > been able to get multiple SQL statements to work in Access. > Is there a trick I'm missing, or is this just something > else to live with and remind me I shouldn't be using > Access? ;-)
2 points; 1) Don't use Access on a live system - it's a Desktop app, not a Server app 2) It depends on which version of Access - 2000 has a new engine on the back end of it, so it handles SQL better - if you're still using 97, then you won't be able to Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
