Skip to main content
February 3, 2009
Question

Updating MS Access Database using an Coldfusion/html form

  • February 3, 2009
  • 3 replies
  • 797 views
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>
This topic has been closed for replies.

3 replies

Inspiring
February 4, 2009
You should also remove the spaces between your field names the the formfield attribute values. The list should be delimited by commas only.
Inspiring
February 4, 2009
Possible issues:
1. Access does not support transactions. The cftransaction tag should be omitted.

2. The dbtype attribute has been deprecated. Unless you are using an old version of ColdFusion you should use the datasource attribute instead.

3. Permissions. Does the account under which the ColdFusion Application Server and/or OBDC services run have sufficient rights to the database file? Note that even though the users have rights to the file the CF service is the user actually touching the file.
February 4, 2009
Which version of CF and Microsoft Access are you running?

There are issues with Microsoft Access 2007 ,which requires the datasource to be first created via ODBC and then add the datasource on CF admin.