Version 8 will be much better. It has usable code in the view designer and you can change the sql code in the designer.

John

>Hi,
>
>I created a remote view (from tables in a local Access DB). Everything went fine whether I used the wizard or if I created the view manually myself.
>
>Once the view is created, I can browse it fine but every time I try to modify it (either by right-clicking on the view and choosing "Modify" or by calling "MODIFY VIEW" in the command window) I get an error:
>

>Command contains unrecognized phrase/keyword.
>

>I have no idea what I am doing wrong or what I need to set for this function to work.
>
>Thanks in advance for all your help.
>
>Stephane.