Null values in Access

[Leigh0563]

Hi, I am kind of new to Access. I recently had to change computers in my office. I had Windows ME when I downloaded Access and made my table. Since I have had to change to a Windows 2000 and transfered my Access tables to there. I can not make any changes on my table because it tells me I have a Null value. What does that mean? How can I make changes again?

 

[melinda]

Null value means Field contain no values.
For Text, Memo, or Hyperlink fields, null value means Zero Lenght string.

if ur database cannot be open maybe there is null value in ur index or primary key.
so i suggest u to check it out before u convert ur database to ms. access 2000.

Hope this information can help.

 

[The_Doc_Man]

Two possibilities to fix this.

1. Write queries that include all fields from your table PLUS one of the fields is chosen a second time with the formula "IsNull([fieldname])" and a criterion of TRUE. The query will show you which records contain nulls. Then you can update them.

2. In order to be able to do this, you might need to enter that table in design mode, visit each field, and remove all indexes. (Make good notes so you can regenerate them later.)

I believe that Null Indexes will have the effect you describe, though other reasons could also cause this.