>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?
Can you post the code for the view? My guess is you probably have an outer join in it somewhere, and you're just now finding a situation where there's no matching record in the related table. If you don't want nulls in your view, make sure you use a NVL() function around any fields that come from a table related by an outer join.