Skip to main content
February 3, 2009
Question

Updating MS Access Database using an Coldfusion/html form

  • February 3, 2009
  • 2 replies
  • 721 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.

2 replies

Participating Frequently
February 22, 2009
Does the application enforce some kind of security?

Sounds like they're logging in via IIS Web Server authentication and hitting some HTML form.

When they hit submit, the CFM page is invoked and Application.cfm checks to see if the user is logged in. If they're not logged in, they're redirected to some automatic login page that checks the IIS set CGI.Auth_User variable and sets up the user?

If during all that... the user is redirected to some home page or something instead of being transparently passed onto the rest of the form submit process, that would give the feeling that the database isn't being updated.
jbird5k
Inspiring
February 17, 2009
Sammy
two things I would do, would be try using a regular sql update statement to see if IIS 7 doesnt like the CF syntax and the other would be the date format. its seems Access, dates and I never see eye to eye.

j.