I have a VFP7 app which attaches to an Access97 database via a remote view. It has worked fine for a long time.
I've just been updating it to use a slightly modified Access97 database, with a few new columns. The RV is defined in code, based on that originally generated by GENDBC. When I now attempt to open the view, I get an error message: "Field TEACHER does not accept null values".
The TEACHER field is not one of the new fields, it's been there all along. Can anyone shed any light on why this is happening, and how to fix it?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up