Re: Cannot Open Access File

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

How do I *Make sure that the account that your web app is running under has
write
permissions on the App_Data folder*?




"Mark Rae [MVP]" <mark@xxxxxxxxxxxxxxxxx> wrote in message
news:%23Jd895zwHHA.3636@xxxxxxxxxxxxxxxxxxxxxxx
"dancer" <dancer@xxxxxxxxxxxxx> wrote in message
news:eYIF2lzwHHA.2076@xxxxxxxxxxxxxxxxxxxxxxx

Data Source=www.wheelers.com\fpbd\Acc.mdb

This is never going to work. See Juan's previous reply - the Data Source
element of the connection string needs to point at a physical file, not a
URL, so:

1) If your web application doesn't already contain an App_Data folder,
create one

2) Place your Acc.mdb database in the App_Data folder

3) Make sure that the account that your web app is running under has write
permissions on the App_Data folder

4) Change your connection string to:
DBConnection = New OledbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data
Source=" & Server.Mappath("~\App_Data\Acc.mdb") & ";"


--
Mark Rae
ASP.NET MVP
http://www.markrae.net


.

Relevant Pages

  • Re: Access to the path is denied when calling StreamWriter from aspx to dynamicaly create asp files.
    ... dynamicaly create asp files. ... I don't know what level of authentication you are using for your web app, ... but you must provide sufficient access to the folder or folders where the files are ... The permissions may apply to the ASPNET account, ...
    (microsoft.public.dotnet.security)
  • VS.NET Create Web Application Hang
    ... We even created a local account for him to ... That local account allows him to create a web app, ... and created with the user as a Domain Admin. ...
    (microsoft.public.dotnet.general)
  • impersonation or auditing issue ???
    ... I have a simple/test ASP.Net web app. ... access a specific file in some folder. ... However the security audit log shows that "UserC failed to access the file" ... not doing impersonation while accessing the file. ...
    (microsoft.public.dotnet.security)
  • Re: Basic question on Windows Integrated Security
    ... IUSR_is not the default Web App Pool identity. ... IUSR_is used by IIS as the account to impersonate for requests ... Pool identity, and is configurable via the Application Pools node in the IIS ...
    (microsoft.public.inetserver.iis.security)
  • Re: head scratcher...
    ... Actually when your web app runs it will run under ASPNET account so that's ... Under 2000 server the rights are more relaxed, ... > takes a file name and opens a file from an nfs mounted directory. ...
    (microsoft.public.dotnet.languages.csharp)