List:General Discussion« Previous MessageNext Message »
From:Christopher R. Jones Date:February 18 2000 4:49pm
Subject:Re: Access 2000
View as plain text  
>> Forget about the decimal thing I mentioned -- that was right.  The problem
>> seemed to be with the "IS NULL" clauses -- I filled in all of the fields
>> that were blank and then Access had NO PROBLEM updating the record.  Is
>> there any workaround for this?
>
>Hm, works fine for us - perhaps we don't have these problems because we
>always define all fields as "NOT NULL"?
>
>regards, Jan
I tried defining the column without NOT NULL but any records with blank
entries in text or char gave the "write" error.  If I places a single
character in all those records then there is no problem.


Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped


Thread
Access 2000Alok Dhir17 Feb
  • Re: Access 2000Graeme B. Davis18 Feb
  • Re: Access 2000Graeme B. Davis18 Feb
  • Re: Access 2000Graeme B. Davis18 Feb
  • Re: Access 2000Jan Legenhausen18 Feb
Re: Access 2000Christopher R. Jones18 Feb
Re: Access 2000Christopher R. Jones18 Feb
RE: Access 2000Alok Dhir18 Feb
  • Re: Access 2000Graeme B. Davis19 Feb
  • Re: Access 2000Jan Legenhausen19 Feb