Well the good news is I am able to get my Access provider to show the surveys (I am using the DotNetNuke Survey project code that is used in the Kevin Weir code example).
The problem I am having now is that is crashes when I try to update the database. I had previously made a non-DotNetNuke test project where I was able to update the surveys and it worked. Therefore, the problem must be the integration with DotNetNuke.
Needless to say it may take me a few weeks to work this out.
I am so glad I set the date to deliver the proposal in August :)