How do I change the default value in SQL for a access DB field?

K

ken

I have found that integer and long integer type fields behave pecularly when
set to the value 32484. If the default value is 0, the database will set the
field to 0 rather than the value. If the default value is null, it sets the
value correctly.

I have some deployed databases for which I would like to change the default
value programmatically. Preferably, I would like to execute a query that
changes the default value from 0 to null. I am using the ODBC interface.
 
Top