check constraint sql syntax help 1

[h0gg1e]

I'm trying to create a simple check contraint in access without going into access's table designer.

basically in sql server 2000 I would do this ....

CREATE TABLE tblCHECKtest
(
item_code char(4)
CONSTRAINT CK_tblCHECKtest CHECK (item_code = '0000')
)

how can I do the above in access via a sql command ... it keeps returning 'Syntax error in CONSTRAINT clause'

thanks for any help

 

[PHV]

JetSQL doesn't admit CHECK in the CONSTRAINT clause.
Browse your computer local drives for files named JET*.CHM

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BNPMike]

PH - A star for that useful tip for finding the Jet Reference.

 

[h0gg1e]

thanks for the insight ... you would think there would be a way to do that, but there isn't .. thanks again.

 

[BNPMike]

To be fair, there is a way. Go into the Table Design Dialogue. Not pure, but - heh - this is Microsoft...