By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 801 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

ASP.NET and Access Database

P: 1
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.
Jul 7 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.