validation text property

[msnews.microsoft.com]

Hi all,

I've created a check constraint on a sql2000 table. In my Access Project
I've set the validation text property at the check constraint.
However, the validation text will not be shown, if my entered data violates
the constraint.
If I login as administrator (sa) or Windows Integrated Security (I'm local
administrator) it will work. But not with different user accounts, which are
not administrators.
I'm using the english version of SQL2000 and Access 2002 SP3
On an other machine running the german version of SQL Server and Access
2002, the validation text will never display.
I tried it with Access 2003 too. It does not work.

I assume, this is a bug in Access. Does anyone know a solution?

 

[Guest]

I face exactly the same problem as Matthias does.

I am working with the German versions of SQL2000 and Access 2003. I am
using Windows Integrated Security. I did not try it as a local administrator,
but only as a local standard user.

If anyone has found a solution to this problem since Matthias' post I would
greatly appcreciate an answer. Thank you!

Best regards
Daniel