>I create view with view designer wizard named "Customer Listing" while saving it.
>I just select all Field from customer table so it's like
>CREATE SQL VIEW AS SELECT * From MyDBC!Customer
>Now If I wish to use this view as
>OPEN DATABASE MyDBC
>USE Customer Listing
>
>then it gives erro; "Command contains unrecognized phrase/keyword." These type of views are
>used with drag & Drop method. What am I doing wrong here? Please guide me.
>
>Note: There is a white space between Customer and Listing in the view name "Customer Listing".
>
>If I create view
>
>CREATE SQL VIEW lv_CustomerListing AS SELECT * From MyDBC!Customer
>
>OPEN DATABASE MyDBC
>USE lv_CustomerListing
>then it's work fine.
>
>Note: There is no white space in the view name.

Try this.....USE ("Customer Listing") or create a local variable like lcView and set it equal to your value: lcView = "Customer Listing", then USE (lcView)
If those don't work, take out the white space.

Steve