Required field

[Guest]

The tables in my Access db are linked to SQL db's.
I need to make one of the fields Required.
In SQL I unchecked the Allow Nulls box, then I ran the link table manager in
Access.
Each record for that value had data so it accepted the update.
But when I open the table in design view and try to change the value to
required it says "The table is linked and cannot be modified"

Suggestions...

 

[Jason Lepack]

Don't try to use design view on a linked table. If you unchecked the
Allow Nulls box then SQL Server won't allow the MS Access application
to write nulls into the table. If you don't believe me, then just try
it.

Cheers,
Jason Lepack