I've worked with Access for a number of years. I just
purchased 2002 Developer and am attempting to transfer a
large database to SQL 2000 as an Access project.
There's a knowlegebase article (ACC2002) which addresses a
problem with table constraints. I appear to be having
much more of a problem then it describes.
In the table I'm working with, I have a number of fields
set for Not Null and I've written a Constraint to not
allow empty strings in the same fields.
In my form when I enter a new record and do not enter the
required information, the record will not move off of the
current record and will not give me a message notifying of
the constraint problem.
Also, when you close the form the record is not saved and
no message is given that it is not saving. I know that
Access.mdb tables do the same thing when you mark a field
Any help would be appreciated if anyone else has had this
problem and has developed a work around.