ACCESS2000 DO NOT ALLOW NULL VALUE

[kelvinfun]

HI

I use ASP with a Access2000 MDB as database, my asp has a
form, not all the fileds must fill.

When the form process input to Access, the Access do not
allow the field is ''(null)

How can I fix this ?

Thanks

Kelvin

[Ray at]

Change your field to accept nulls, or preferred, don't try to leave it null.
If you were inserting '', that would be fine. My guess - without seeing
your code - is that you are skipping the column in your INSERT, like:


table1:
ID (autonumber)
Firstname (text)
Lastname (text)

And you're doing:

INSERT INTO [table1] ([Lastname]) VALUES ('Lee')

instead of

INSERT INTO [table] ([Lastname],[Firstname]) VALUES ('Lee','')

Ray at home

"kelvinfun" <kelvinfun@hotmail.com> wrote in message
news:f68901c38307$e2346480$a601280a@phx.gbl...

> HI
>
> I use ASP with a Access2000 MDB as database, my asp has a
> form, not all the fileds must fill.
>
> When the form process input to Access, the Access do not
> allow the field is ''(null)
>
> How can I fix this ?
>
> Thanks
>
> Kelvin
>

[Bullschmidt]

In the Access table change the field's AllowZeroLength property to be Yes or
else convert Nulls to "" before saving to the table.