I am in the unfortunate position of attempting to work with an Access database on a network share. My client has two separate access databases - one that contains all of the company's data and one that contains a full blown application (forms, module, reports, etc) that reads from the aforementioned data only access db. I've been tasked with developing a web page that displays data about customer service calls - all of the relevant data is contained in the first access database mentioned above.
I created an ASP.NET page and employed AJAX and a timer to have a panel continually update with call statuses. I created a single query in the access database that pulls down the data I need to report on.
On the ASP.NET page, I created an AccessDataSource:
<asp:AccessDataSource ID="dbParatrac" runat="server" DataFile="\\servername\Database\app\somedb.mdb"
SelectCommand="SELECT [Loan Count] AS Loan_Count, [Collector], [Day] FROM [qryWEBCollectorCounts]" DataSourceMode="DataReader">
</asp:AccessDataSource>
I then bind the datasource to a gridview.
When I run the application from Visual Studio, no issues - it works fine. However, when I attempt to go through my browser to localhost, I get the dreaded OleDB permission error that the app is locked by another user or I don't have permissions. I attempted to use impersonation with my user account with no success (I have admin privileges so this should have worked).
I'm at a loss as to how else to fix the problem. Any help would be most appreciated.