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.