Hi Barry,

Did you try to create views in code? Do they work? If they do that it's a problem with Advantage ODBC driver.

UPDATE:
Check Re: VFP and Advantage DB Thread #800305

>Hi
>I'm having trouble connecting to an Advantage DB Server through VFP8. I'm using the Advantage ODBC driver and setting up a connection in my DB. That's fine, but when I try to design a remote view I get a Fatal error:Exception code=C0000005.
>No matter what I do this seems to be the problem.
>Anyone know of a workaround?
>Many thanks,