Thank you Ray, but I would rather not do that. This would give you access to the complete site and that is too big of a risk.
Let me list the things that I tested and ther results:
Using the same connection strings:
Getting data from a table: Ok in DW Dialogs, (WA) Ok on webpage
Getting data from a View, NOT listed in Views in the Advanced Recordset Dialog )WA)
Getting data from a View, listed in Tables in the Advanced Recordset Dialog: (WA), View Listed, Dialogs OK, No data on the web page