Required field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
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
 
Back
Top