I finally have the Access provider working. you can now switch between the Kevin Weir SQL code and the Access provider by simply changing the lines below in the "dataConfiguration.config" file

      <instances>
        <instance name="DotNetNuke" type="Sql Server" connectionString="Sql Connection String" />
        <instance name="DotNetNuke_oleDB" type="OleDB" connectionString="OleDB Connection String" />
      </instances> 

The instance that is called "DotNetNuke" will be the one that runs.

I will now take a week to polish this up and make a PA that I will post for testing.