I've created a remote view of an MS Access table located on our LAN. The view works fine, but if I try to modify the view in the View Designer, I get a "Syntax Error". The Access table field names have imbedded spaces, so the SQL code originally created by the View Designer includes fields names such as:

tblTablename."field name"

If I select all fields so that my SQL statement begins with:

SELECT *;

modification is no problem unless I try to order the cursor which again uses the tblTablename."field name" format in the ORDER BY clause. How do I get around the problem that appears to be caused by the imbedded spaces in the field names of the Access Table so that I can use the View Designer on the view?

Thanks.