Thanks in advance for any insight or help with this issue.
I have used the Database Interface Wizard to create an interface for a website. The entire site, Add, Update, and Deleting records work great when the site is run locally on my machine.
When I publish the site to my hosting service, the Update record page ceases to function properly. I get the following error after submitting the form.
Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide default values for all form fields that are used in the query.
If I fill all the fields in I get the following error.
Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
I have done every fix and workaround that I have found on every possible website that I have searched. I have default values in the Database Results Properties. I have ensured that I am not using any reserved words in Access. I have ensured that I have the proper folder/file permissions set on the server. I am not inserting any dates, and I have the database set up to accept blank/null values.
I don't understand why the update works fine on my local machine, but not when published. Below is the auto-generated fp code of the query.
fp_sQry="UPDATE Results SET Prefix = ':
refix::' , FirstName = '::FirstName::' , LastName = '::LastName::' , Address = '::Address::' , City = '::City::' , ST = '::ST::' , Zip = '::Zip::' , Phone = ':hone::' , Email = '::Email::' , Sex = '::Sex::' , Year = '::Year::' , SwimDive = '::SwimDive::' WHERE Key = '::Key::'"
fp_sDefault="Prefix=&FirstName=&LastName=&Address=&City=&ST=&Zip=&Phone=&Email=&Sex=&Year=&SwimDive=&Key="
Any ideas, suggestions, comments are greatly welcomed.
Thanks,
Jason Burden
I have used the Database Interface Wizard to create an interface for a website. The entire site, Add, Update, and Deleting records work great when the site is run locally on my machine.
When I publish the site to my hosting service, the Update record page ceases to function properly. I get the following error after submitting the form.
Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide default values for all form fields that are used in the query.
If I fill all the fields in I get the following error.
Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
I have done every fix and workaround that I have found on every possible website that I have searched. I have default values in the Database Results Properties. I have ensured that I am not using any reserved words in Access. I have ensured that I have the proper folder/file permissions set on the server. I am not inserting any dates, and I have the database set up to accept blank/null values.
I don't understand why the update works fine on my local machine, but not when published. Below is the auto-generated fp code of the query.
fp_sQry="UPDATE Results SET Prefix = ':
refix::' , FirstName = '::FirstName::' , LastName = '::LastName::' , Address = '::Address::' , City = '::City::' , ST = '::ST::' , Zip = '::Zip::' , Phone = ':hone::' , Email = '::Email::' , Sex = '::Sex::' , Year = '::Year::' , SwimDive = '::SwimDive::' WHERE Key = '::Key::'"fp_sDefault="Prefix=&FirstName=&LastName=&Address=&City=&ST=&Zip=&Phone=&Email=&Sex=&Year=&SwimDive=&Key="
Any ideas, suggestions, comments are greatly welcomed.
Thanks,
Jason Burden