ODBC Trouble with Access 2003

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

I am deveoping a form with ColdFusion/Access and this is
my first time using Access 2003. It will not allow me to
submit an incomplete form, even though I have created my
database to allow null values and do not require each
field filled to create a record. Anyone else experiencing
this?
 
In the database design, take a look at the properties for each field you're
having a problem with. Certain types of field in Access have the property
"Allow Zero Length". Even if you have set the property "Required = No", you
may also need to set "Allow Zero Length" to No as well to make the field
really "optional".

David Straker.
 
Thanks for the response Dave, actually I did set those all
properly, I have learned that lesson. As it turns out I
found the answer on an old message board. The problem is I
was trying to use "Number" instead of "Text" fields like I
always used to. Text fields are much less finicky it
seems. I changed anything that would be receiving data
from the form to text and solved the problem.

Happy Developing!
 
Excellent dude. I never know the level of expertise of a poster so I usually
pitch replies pretty low to start with.

Glad you found the solution.
David S
 
Back
Top