[AccessD] An interesting "feature" in SQL Server

That's a good approach, David. The rest of this thread really causes skin
rash due to its misunderstanding of the purpose of NULL values. NULL is a
valid value. I've said this before and I'm saying it again. Force a NULL
value to anything else (which includes defaulting a column to some value) is
IMO a fundamental design error, indicative of one of two problems:

1. you don't understand the data domain
2. the domain itself is incoherent.

My $.02.
Arthur