Validation rule playing up

[Kalmed2018]

Hi all,





I use a database with many different tables, forms, queries etc. The basic table contains fields like first name, surname, date of birth, address etc. For the surname field i use a validation rule: Like "a*" Or Like "b*" Or Like "c*" Or Like "d*" Or Like "e*" Like "f*" Or Like "g*" Or Like "h*" Or Like "i*" Or Like "j*" Or Like "k*" Or Like "e*" Like "f*" with the validation text: Only for A - K Surnames. Otherwise please use L - Z My Practice. It has been working perfectly fine for a few months now. However, over the past few weeks it will not allow me to use surnames starting with "E" or "F" and every time i try one of these letters i get the validation text. It still works as expected for all the other letters of the alphabet. Did anyone have any similar problems? Is there any solution to that?



Many thanks,


ps: the reason for the validation rule is that my database became too big (over 2 GB) and I chose to split in half, one for clients A-K and one identical for L-Z.

[davegri]

Missing Or?
Or Like "e*" Or Like "f*"

[Minty]

How many records do you have that have made it exceed 2Gb ?
Have you tried a compact and repair ? Is the database split ?

[Kalmed2018]

Hi Davegri,

you were right! i added the Or and it works fine again. I can't understand how that happened as definitely the syntax was correct to start with as it has been working for a few months now and i had used e and f before! Anyhow, thank you for your help and for your interest!!
Best wishes.

[Kalmed2018]

i know, it is insane. Perhaps it is not the nember of records that much as the structure of the database that consists of meny diferrent tables interacting together. As i am quite novice and this is an important database i wouldnt consider a restructure. Compact and repair did not reduce the size significantly. Thank you for your interest!

[davegri]

Kalmed, the sneaky Access hacker sometimes appears and changes my code too!
We must remain vigilant.