Well, i tried making the connection on the fly but no luck Only by going to the ODBC connection icon in the control panel and creating it there was I able to get the views to work. What gives??

Sandy