Query to change the default column value in a table
Posted on 2008-02-12
I have an Access 2003 Database in which I would like to run a query to change the default values for several columns within a table to NULL. Is it possible to write a query without VBA to do so?
I created a new query went to the SQL view and entered in the following:
ALTER TABLE My_Table ALTER COLUMN My_Column LONG DEFAULT NULL
Access lets me save the query; however, it appears to do nothing when run.
FYI: I already removed the relationships regarding this column.