Hi Stephane,

The View Designer leaves much to be desired. After much ripping of hair and gnashing of teeth I finally stopped using the View Designer and I now create my views in code. I don't have any problems now with views and the complexity of views I can create is much increased.

Regards,

Liam


>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.