I need to write some code that will convert an existing field in a table in
both an Access and SQL Server database from being required (NOT NULL) to not
required (NULLable).

I've got this working in SQL Server very easily using the following SQL
statement:

ALTER TABLE MyTable
ALTER COLUMN MyField varchar(50) NULL

....assuming the MyField column was not nullable before, after executing the
above code it will be.

However, I can not get this to work in Access. I've executed the following
code:

ALTER TABLE MyTable
ALTER COLUMN MyField text(50) NULL

....and it executes without error, but when I go into Access and examing the
table, the field is still marked as required.

Can anyone suggest a way of getting this to work? I'm using ADO to perform
the changes, and DAO isn't available on the target machine.

Many thanks,

--

Adam.