Yeah, that should work. I just tried it myself and it doesn't want to work for me either. I'm wondering if there's either a bug in the new versions of Access that nobody has caught yet (doubtful) or Microsoft changed it somehow. Let me do a little research. A quick Google search shows nothing. Unfortunately, this is one of those things I almost never use personally. If I'm going to create a table, I'll use a Recordset. :)

OK. I think I found the reason. Hang on while I test it. I like to be sure before I explain.

Alright... it's been 10 years since I recorded this seminar (wow) so I forgot about this. I don't use SQL to create tables on a daily basis (like I said, I use Recordsets, which I'm going to teach in an upcoming lesson very soon). However, in order for this to work from lesson 8, you have to have first watched lesson 7. In lesson 7, I explain that you have to switch your database to follow ANSI 92 rules (basically SQL Server syntax). If you don't, Access by itself doesn't support the CONSTRAINT - CHECK syntax you're using. Watch lesson 7. But thanks for asking me this... it was a good refresher. First thing to start off my morning was re-remembering something about Access that I knew 10 years ago but have since forgotten because I don't use it all the time. LOL

LOL! Watched Lesson 7 while multitasking. Not a good idea. Switched to 92 and all is good. Thanks Again.