Your very last field (OS_Cyl) is missing a value (OS_Cyl = 'XX'
OD_Cylinder = '19' , OS_Cyl
| Can anyone give me some pointers on my problem listed below?
|
| "RJP" wrote:
|
| > This is what I tried so far: I went to
| >
http://support.microsoft.com/kb/287147#kb3
| > and realized that I have no SQL Timestamp line in my code. I then hit
| > "verify query" and this error message popped up:
| >
| > Server error: Unable to retrieve schema information from the query:
| >
| > UPDATE Results SET Name = '1' , Address = '2' , Date = '3' , City = '4' ,
| > State = '5' , Zip = '6' , Home_Phone = '7' , Cell_Phone = '8' , Tray_Number =
| > '9' , Doctor = '10' , Measured_by = '11' , Location = '12' , Materials = '13'
| > , Lens_Type = '14' , Tint = '15' , Color = '16' , OD_Sphere = '17' ,
| > OS_Sphere = '18' , OD_Cylinder = '19' , OS_Cyl
| >
| > The following error message comes from the database driver software; it may
| > appear in a different language depending on how the driver is configured.
| > -------------------------------------------------------
| > [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
| >
| > Source: Microsoft OLE DB Provider for ODBC Drivers
| > Number: -2147217900 (0x80040e14)
| >
| > Please help!
| > RJP
| >
| >
| > "RJP" wrote:
| >
| > > I opened the database and all of my fields were selected to allow zero
| > > length. What should I do now? Still can't edit
| > >
| > > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >
| > > > Open the database in Access (you may need to export it from your web first).
| > > > Open the table that contains that field in Design View, find the field, and
| > > > change the settings under General (at the bottom of your screen).
| > > >
| > > > --
| > > > ~ Kathleen Anderson
| > > > Microsoft MVP - FrontPage
| > > > Spider Web Woman Designs
| > > > web:
http://www.spiderwebwoman.com/resources/
| > > > blog:
http://msmvps.com/spiderwebwoman/category/321.aspx
| > > >
| > > >
| > > >
| > > > > I found the same problem that another user had and he corrected it
| > > > > and said how to do it, however I don't understand it. Can someone
| > > > > clarify it for me. The fix is below.
| > > > >
| > > > > Found the problem in the Access Database...
| > > > > Even though I had the "Required" of each field set to "No" - I had to
| > > > > set the "Allow Zero Length" - to "Yes" - now everthing works great!
| > > > >
| > > > >> Hello. When I try to edit a database entry from the database editor
| > > > >> I get this error message.
| > > > >>
| > > > >> Database Results Wizard 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.
| > > > >>
| > > > >> My site address and the link for the database editor is:
| > > > >>
http://www.catalanooptics.com/operatormain.htm
| > > > >>
| > > > >> user name is: catalanoopt
| > > > >> password is: lg123
| > > > >>
| > > > >> Enter the user name/pass all in lowercase.
| > > > >>
| > > > >> Thanks for any help.
| > > > >> RJP
| > > >
| > > >
