How can I change a required field to an optional one?

Question

SQL

How can I change a required field to an optional one with a query? I use MS Access

Answer 1

If there are no related fields, then 4 queries:
1. Copy of the desired table
SELECT original.* INTO temp FROM original
2. Delete original
DELETE original.* FROM original
3. Copy back to original
SELECT temp.* INTO original FROM temp
4. Delete copy
DELETE temp.* FROM temp
If there are links to other tables, then create a new field and then reconfigure links to it
ALTER table original add Column [column name] Double