I finally got it to work on the server using the following connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\10.0.40.33\mstest1.com\public\data\thscData.accdb;Persist Security Info=False;"
The problem that I was having was because when I test locally I use this connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Inetpub\wwwroot\mstest1\data\thscData.accdb;Persist Security Info=False;"
and I was not switching to the server connection string prior to testing on the server. My question is:
Is there a way to automate which connectin string is used depending on where program is being used (local vs server)? Or do I have to manually switch back and forth between these two connection strings?