Validation Rule Edit

[wobble12]

I am a novice when it comes to editing how a database works, but I have an old Access database that a clever chap designed many years ago.

Its a waste database, and the quantity field has a validation which limits the value between 0 and 400.
I need to increase this between 0 and 2000. However, I have found the properties field where the rule, and it won't let me edit the value. Even when I go into expression builder and actually edit the rule, it won't update I the main field.

If there a way to edit this please?

 

[wobble12]

"not working" means what?
You can't make the rule work when adding data to the table, or it works then but not when adding by using a form?
You make the changes and save the table design and there are no messages but the change doesn't stick?
You make the change, it saves but you can't enter anything higher than 400?
Something else?

I'll be traveling on the road today so I may not be back to this today.

Ah! The bit I wasn't doing was saving it!

Thank you all for your input, much appreciated.

It also saved it from being a .mdb to an .accdb file. I assume this is a good thing.

 

[welshgasman]

It also saved it from being a .mdb to an .accdb file. I assume this is a good thing.

I would say not really, but does not hurt, now you have a later version of Access.

FWIW you have to save ALL changes in Access.

 

[Micron]

FWIW you have to save ALL changes in Access

Design changes yes; records are another matter.

I do not see how you could have repeatedly made the design change and then dismiss the save prompt when you went to close the table or put it in datasheet view.
Anyway, glad we could help and thanks for the recognition.