<Null> of the fields in the table (1 Viewer)

Hi,

In SQL Server, I have one table called "tbl1".
I have 3 fields, f0,f1,f2
f0 is primary key

I linked this table to MS Access. I insert data of the f1 in MS Access environment, and delete it, the <Null> value is still shown in SQL Server table, if I delete the value in SQL Server table, then <Null> value will not be shown on the table. Why MS Access can populate <Null> value to the SQL Server? How can I set <Null> in the SQL Server? Must I use update statement to do that?

Hi there,

I dont think this is due to access propulating the table with null I think it is due to the transaction not being committed, try the following as a test...

enter a record in access
delete record in access
close table in access
re-open table and check to see whether null has disappeared

Hi there,

I dont think this is due to access propulating the table with null I think it is due to the transaction not being committed, try the following as a test...

enter a record in access
delete record in access
close table in access
re-open table and check to see whether null has disappeared