Compile error

%3CLINGO-SUB%20id%3D%22lingo-sub-1563906%22%20slang%3D%22en-US%22%3ECompile%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563906%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Access%202002%2C%20Table%2C%20Design%20View%2C%20I%20keep%20getting%20%22Compile%20error.%20In%20Table-Level%20Validation%20Expression%22%20when%26nbsp%3B%20I%20try%20to%20save.%20Then%26nbsp%3B%20when%20I%20try%20to%20leave%20to%20go%20to%20another%20view%2C%20it%20says%20i%20have%20to%20save%2C%20and%20the%20cycle%20starts%20over.%20What%20is%20table-level%20validation%20expression%2C%20I%20don't%20think%20I%20have%20entered%20any%20validation%20expressions%20at%20all.%20Kind%20of%20new%20at%20this%2C%20and%20I%20could%20use%20some%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1563906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20Web%20App%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

In Access 2002, Table, Design View, I keep getting "Compile error. In Table-Level Validation Expression" when  I try to save. Then  when I try to leave to go to another view, it says i have to save, and the cycle starts over. What is table-level validation expression, I don't think I have entered any validation expressions at all. Kind of new at this, and I could use some help.

1 Reply

@Dwrobins0968 

 

Just to be sure we're on the same page. Access 2002 is pretty old and has not been considered a viable version since Access 2003 was introduced, and that too is long out of date. If that's the only option open to you, so be it. But I would strongly consider upgrading.

 

So, the validation rule is one of the possible properties you can define for a field in a table. It is an expression which controls what kind of values can be added. E.g. perhaps it would limit values in a number to only positive values. 

It's possible you've accidentally typed something into that property, and that is what causes this problem.

 

 ValidationRule2003.png