HI,
I searched in MSDN.microsoft.com and I found something :
Article ID: Q138501
PRB: Modifying a Remote View Results in a Syntax Error
--------------------------------------------------------------------------------
The information in this article applies to:
Microsoft Visual FoxPro for Windows, version 3.0
Microsoft Data Access Components version 2.5
-------------------------------------------------------------------------------
SYMPTOMS
After you create a remote view to gain access to a remote data source through ODBC, any attempt to modify the remote view results in a Syntax Error.

CAUSE
One or more of the field names in the tables included in the remote view contains a space or other special character, such as one of the following:

~ !

RESOLUTION
Do not add tables that have spaces in field names to a remote view. Use the underscore (_) character in place of a space. Alternatively, use the CREATE SQL VIEW command to modify the remote view. Follow the same naming conventions used for table and field names.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------

I simply created a local view on the remote view and it solved my problem . I am still wondering if there is not a simpler way to accomplish the task.

Thank you,
Christian Cote