I have tried searching the forums here, but that function seems to be broken. Hasn't worked for a few weeks now. So if this is a redundant post...Sorry.

I am new to MySQL and have created a database with a MS Access front end. Everything works great, but I want to limit users from adding incomplete records. I thought the "Not Null" setting would not allow users to add records with Null values for the fields I specified, but they get added anyway. Does anyone know how to do this? I''ve got more experience with Access and wish the "Required" setting in Access existed in MySQL, but it doesn't.

Any ideas would be appreciated. Thanks in advance!

Pat

NOT NULL means the column may not have a NULL value

so NOT NULL is what you want, it prevents an incomplete row from being inserted if any of the NOT NULL columns does not have a value assigned for the new row

you could designate a DEFAULT value for all the columns that the users might potentially omit

what results do you get when you run this query: