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
