Split database not recognizing data validation rules

[JoeCson]

I have a database with a validation rule "Like "T##[NS]" in a text data field with a data entry form front end. In a stand alone database the data entry form works fine

I then split the database. When I try to enter the data I get the following error:

One or more values are prohibited by the validation rule 'Like "T##[NS]" set for Pool.Township'. Enter a value that the expression for this field can except.



Why does the validation rule work stand alone and has an error when the database is split. I do have read/write privileges to the directory with the back-end database

thanks

Joe

[ranman256]

What is the backend?
# works for SQL server,but not in Access.
Access uses *.

[HiTechCoach]

I have a database with a validation rule "Like "T##[NS]" in a text data field with a data entry form front end. In a stand alone database the data entry form works fine

I then split the database. When I try to enter the data I get the following error:

One or more values are prohibited by the validation rule 'Like "T##[NS]" set for Pool.Township'. Enter a value that the expression for this field can except.

Why does the validation rule work stand alone and has an error when the database is split. I do have read/write privileges to the directory with the back-end database

thanks

Joe

Joe,

Where are you dong the validation, table or form?

[JoeCson]

I am doing the validation on the table.

[aytee111]

Don't know why it doesn't work on split. It is generally accepted, however, as a bad idea to do things like this on tables, you can put it on the form field instead.

[HiTechCoach]

I am doing the validation on the table.

Thank for he update. I will have to test to see if it will work.

FWIW: I start ever Access application split from the start. I do all my validation at the front end level to reduce traffic to the back end. It also allows me to give better feedback to the user.