Null values vb6 + access97 [modified]

[spruha369]

I m using vb6 and access 97 for a project i m entering data in the access but the problem is when i insert null values(Empty String) it give 'syntax error in insert into statement' when i enter all the value it doesnt give any error but sometimes it happens that i dont want to enter some values what can i do ?? pls help me... spruha

modified on Monday, June 29, 2009 6:41 AM

[Rajesh Anuhya]

Check your Database field which you R Trying to insert null value is not a required filed in that table, and it's not a *NOT NULL* Field.

Rajesh B --> A Poor Workman Blames His Tools <--

[spruha369]

i check access for any option so that i can it will accept null values(Empty String) i can't see any option for tat... spruha

modified on Monday, June 29, 2009 6:40 AM

[Steven J Jowett]

VB6 and Access 97? Why are you developing in dead software/languages?

Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.

[Thomas Krojer]

If the field is able to store NULL values, then you should also use the NULL in your insert statement: insert into table (field, field, ...) values ('value', null, ...

[paas]

In the design of the Access database table in question, ensure that the field is set to 'Allow Zero Length' and that it is not 'Required'.

[spruha369]

RESOLVED

purvas

[Nagy Vilmos]

Don't think Access'97 supports null strings.

---

Panic, Chaos, Destruction. My work here is done.