My company recently upgraded from a WIN2K/CF6 environment to a WIN2003
Server/CF7 environment with all the latest patches etc. We moved all the
scripts over and registered all the database sources within the coldfusion
administrator. The majority of the scripts use MS Access databases and are all
suddenly failing with previously fine cfinsert queries. I verified that if I
change the cfinserts to cfqueries and do a full sql INSERT INTO statement, the
query is successful. The error we get from the cfinsert is a data type
conversion error.

I am not sure if this is related, but an MSSQL database is also acting
strangely. It correctly connects to the database etc, but returns an invalid
object name on the table name. I thought it might be a permissions problem,
but the dbo is the correct username/password and the table does exist.

Anyways, is there something that we may have forgotten to configure? Why
would these scripts suddenly break?