I was able to get it to work testing locally using the following OLE DB connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Inetpub\wwwroot\mstest1\data\thscData.accdb;Persist Security Info=False;"
However it still does not work on the server.
I checked the path as you suggested and this is what came back.
When I run it locally I get:
DB Path: c:\inetpub\wwwroot\mstest1\data\thscData.accdb
When I run it on the server I get:
\\10.0.40.33\mstest1.com\public\mstest1\data\thscData.accdb
I think the correct path to the database on the server is:
\\10.0.40.33\mstest1.com\public\data\thscData.accdb
I've tried severl different things and I still cannot get the connection to work on the server.