Should I even bother moving to asp.net?

This question is irrelevant if it is not possible to access the Views of a SQL database in Web Matrix!!

We have an unusual situation that I am curious about. Our POS software is very industry specific, and runs on unidata. The software provider has developed an SQL datawarehouse that exports the data nightly, so that we can use it for querying. As a result I do not have (and do not want!) access to write to the tables, as that will cause corruption between the SQL and Unidata data.

The provider has created Views that we do have rights to. I currently use these by simply pasting queries into Frontpage, which generates the .asp script for me. Recently, someone suggested that I try Web Matrix. When I try to attach to the database with Web Matrix, it shows only the tables and I get permission denied when I attempt to authenticate.

First of all, can I get Web Matrix to use the Views for creating my data grids. Second, would it even be worthwhile pursuing this, or is Web Matrix's increase in functionality over .asp more geared towards write functions as opposed to read only?

Thanks for your time on this issue!

The big advantage of using something like Webmatrix is that it will automatically update your web pages for you every time the data changes. Thus if you persevere with it, and get there evenetually, you will save yourself lots of time in the long run.
If you have a query and access rights (usename and password) to read data from the SQL server, then you can use webmatrix to automate the task you are doing manually. It seems strange to me that you can see the database tables but can't read them, you must already be authenticated to even see the tables? There is a really nice book on Web Matrix authored by Mike Pope, it was how I got started with this stuff and since ASP.Net 2.0 is nearly out, you can probably pick up a discounted copy pretty cheap.
If you want help from these forums its always a nice idea to post some code and ask why its not working- its quite difficult from the description above to say what's going wrong and why. We all had to learn once, and you'll nearly always get a good quality, timely response to questions when asked with something that is obvious to work with.
good luck :)