Recent content by Andyonline

well dissappointing as it was to get not one single reply, i thought i'd share what i found in case anyone else is stuck- and that is access does'nt seem to support much in the way of constraints, and you'd need to be using SQL server for them to work.

Anyone?Im still banging my head up the wall with this one,be happy for any advice.

just to add,i know i can use access2007 to add constraints via gui option, but i need this working in sql.

hi everyone, im trying to use constraints in sql queries to control a few things as a create a table, like on one table i want to control the allowed menutypes (lunch,dinner etc) and on another im trying to restrict an amount of money to be between two values.Trouble is i can't get either to...