Remove Nulls error

[p]

We are using Access 2000 with a upsized database on sql 2000 using odbc
linked tables. The database creators used NULLs in every table and column
in database. I want to replace most nulls with datatype defaults (except
datetimes). I changed a varchar for a textbox to not use nulls in sql
server. I then "refreshed" database in "linked table manager" but now I keep
getting this error, when I backspace over the textbox entry, and tab? I
also get same error when switching a dropdown box. Is there something I am
missing to resolve this?

"You tried to assign the Null value to a variable that is not a Variant data
type."

Thanks in advance.
P

 

[Arvin Meyer]

Run an update on the null fields and insert the default value in any of the
that require a value. I would do this directly on the server with a stored
procedure.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[p]

Arvin,
We are using a mdb not adp so I cant use stored procedures.
p