Using Microsoft Access Import Feature with ASP

[fsutton12]

Hello All,

I'm looking for the fastest way to bulk load data into Microsoft Access using the Access import feature from an
ASP page via IIS. When I try to instantiate Access.application() I'm getting an authorization error.

Here is the code:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim B As Object
B = New Access.Application()
B.Visible = True
B.OpenCurrentDatabase("d:\mydb.mdb&quot
End Sub

IIS is throwing the following exception:

Exception Details: System.UnauthorizedAccessException: Access is denied.

The ASP.NET process is not authorized to access the requested resource. For security reasons the default ASP.NET process identity is '{machinename}\ASPNET', which has limited privileges. Consider granting access rights to the resource to the ASP.NET process identity.

To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the "{machinename}\ASPNET" user. Highlight the ASP.NET account, and check the Write box in the Allow column.

Any suggestions?

Thanks

Frank Sutton