ACCESS 2000 and the 'Insert into' statement
Posted on 2002-04-04
I have a simple insert into query written in ACCESS 2000. I also have an ASP
page that takes a few fields and inserts then into an Access table via ADO
and an access query. Everything works fine UNLESS I do not use all of the
fields. Some of the fields are optional which include 3 text fields, 2
numeric fields and 2 date fields. How would I go about allowing those fields
that are empty to be passed into the Access query as have default values set
in the database?
My ASP Error:
Microsoft JET Database Engine (0x80040E14)
Syntax error in parameters clause. Make sure the parameter exists and that
you typed its value correctly.
PS: I have the database setup to allow zero-length fields in the text fields
and the other numeric and date fields are set to be non-required fields. I
have a feeling that this is ADO, not Access??