Access SQL alter table add constraint
I am trying to add a check constraint to an existing table in Access. The following code receives a syntax error, but for the life of me, I cannot figure out why. Any help would be greatly appreciated.
ALTER TABLE <mytable>
ADD CONSTRAINT ck_something CHECK (<field name> <= 500);