I think so, but you have to be very careful to use ODBC for anything "special" in the SQL. If your dates are in ODBC Date Format, they should work for both. I haven't done this for a long long time so I don't remember the syntax, but I'm mostly positive that it CAN be done. -----Original Message----- From: Rich Tretola [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 1:43 PM To: CF-Talk Subject: Access 2000 and SQL 2000 Query Question Question about SQL 2000 and Access 2000. Is it possible to have an application that will run using either Access 2000 or SQL 2000 DB? I am having trouble with datatypes when it comes to money. For example I have an update query that updates a money SQL datatype and a currency Access datatype. I have to use the single quotes '#whatever#' for Access and no single quotes #whatever# for SQL 2000. So is it possible to have an app run on both databases without any code changes or is the way I am doing it now the only way possible. Thanks, Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
