Topic: Access validation rule problem
Although we haven't yet sorted out the support contract yet we have agreed to use this forum for support. Thus we can log problems here and possible temporary solutions which hopefully will become proper solutions in time.
On adding a BAP habitat to a polygon I was getting a problem with the validation rule "Like "PHAP*"". This meant that although other changes were saved It would not save the BAP habitat data for the polygon. The rule looks fine but there's something wrong with it. I removed the rule for the bap_habitat field in the incid_bap table and it now works. This will temporarily get over the problem but it does need a proper fix so the validation works and doesn't cause problems.
Thames Vallley Environmental Records Centre