Question
Updating MS Access Database using an Coldfusion/html form
I just moved over from IIS 6 (Windows 2003) to IIS 7.0
(Windows 2008) Server. My users were able to authenticate into the
Windows 2003 box, make changes to a Coldfusion/html Form data and
submit them with the new data stored in an Microsoft Access
Database.
Now under IIS 7 they can authenticate in successfully, make changes to the Form (Coldfusion/html), submit it (with no errors displayed)... but the data is not updated in the database. Can anyone help me with this?
They have Full Control Security rights to the directory where the database is located.
The FORM is actually HTML and not Coldfusion. However, the following Coldfusion tags are used to store the data on the server.
RECORDS ARE UPDATED USING:
<cftransaction>
<cfupdate datasource="PublicRelations"
dbtype="ODBC"
tablename="MainCalendarTbl"
formfields="ID, eDate, Item1, Item2, Item3, Item4, Item5, Item6, Item7, Item8, Item9, show">
</cftransaction>
NEW RECORDS ARE CREATED USING:
<cftransaction>
<cfinsert datasource="PublicRelations"
dbtype="ODBC"
tablename="MainCalendarTbl"
formfields="eDate, Item1, Item2, Item3, Item4, Item5, Item6, Item7, Item8, Item9, show">
</cftransaction>
Now under IIS 7 they can authenticate in successfully, make changes to the Form (Coldfusion/html), submit it (with no errors displayed)... but the data is not updated in the database. Can anyone help me with this?
They have Full Control Security rights to the directory where the database is located.
The FORM is actually HTML and not Coldfusion. However, the following Coldfusion tags are used to store the data on the server.
RECORDS ARE UPDATED USING:
<cftransaction>
<cfupdate datasource="PublicRelations"
dbtype="ODBC"
tablename="MainCalendarTbl"
formfields="ID, eDate, Item1, Item2, Item3, Item4, Item5, Item6, Item7, Item8, Item9, show">
</cftransaction>
NEW RECORDS ARE CREATED USING:
<cftransaction>
<cfinsert datasource="PublicRelations"
dbtype="ODBC"
tablename="MainCalendarTbl"
formfields="eDate, Item1, Item2, Item3, Item4, Item5, Item6, Item7, Item8, Item9, show">
</cftransaction>
