I'm getting a server error in my ASP.NET 2.0 application when trying to access an Access database. This is the error message:
"Access to path to the database was denied. The location does not exist or is not accessible because of security settings".

I'm using a GridView control with AccessDataSource.
The Access database is on Windows Server 2003 with IIS 6.0, ASP.NET 2.0, and SharePoint 3.0

This is the ASP.NET code:

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/UFR_db.mdb"
SelectCommand="SELECT * FROM [Projects] WHERE ([POCID] = ?)"
OldValuesParameterFormatString="original_{0}">
<SelectParameters>
<asp:SessionParameter Name="POCID" SessionField="User_ID" Type="Int32" />
</SelectParameters>
</asp:AccessDataSource>

I've tried each without success,
1. changing the DataFile to the complete path and every other variation
2. changing the "/" in the path to "\"
3. giving folder and file permissions to
a. NETWORK SERVICE
b. ASPNET
c. Internet guest account
d. IIS Process Account
e. Everyone

I also tried changing the Enable/Disable anonymous access method and turn on/off Integrated Windows
authentication in the Web Site properties. None of these fixed the error.

Anyone have a solution to this problem?

Assuming the database is on the same machine as the web server I would highly recommend using a full path name to the file.

A couple of other questions, what level of authentication is your web application configured for? Is impersonation enabled?

I've tried using the full pathname but that didn't work.

I'm using Integrated Windows authentication and don't have impersonation enabled. Both the database and ASP.NET application are on the same Windows 2003 Web server. I didn't change the default on the server, ASP.NET is executing under the NETWORK SERVICE account.

Also, I'm able to access the database with C# from some code-behind on one of the .aspx pages. I use the ConnectionString from the web.config and an OldDbConnection.

Under this scenario the local NetworkService account will need full permissions to the folder where the Access database is located.

Now if you're able to work with the database via code then that would indicate there's a problem with how you're connecting with the DataGridView.