Null character in Acess 97 ValidationRule after amending with Access 2000
Posted on 2006-11-28
I have an application with the usual front-end/back-end split. To slightly complicate matters, the front-end is Access 2000, whereas the back-end is Access 97.
I've recently added an update procedure to the front-end to programmatically 'tweak' the validation in various back-end tables (using DAO). Unfortunately, whenever the Access 2000 front-end manipulates the ValidationRule property of a field in the Access 97 back-end, it appends a vbNullChar character to the end of the string.
Bizarrely, this null character is only noticed by Access 97 - where it causes a syntax error whenever the validation rule is evaluated.
Does anyone know how I can remove the unwanted character, USING ACCESS 2000?