Re: DB connection PB.

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

From: William Burrows [MVP] (burrowsREMOVEME_at_u.washington.edu)
Date: 03/23/04

  • Next message: ptreves: "Re: DB connection PB."
    Date: Tue, 23 Mar 2004 14:28:30 -0800
    
    

    Paolo,

    When you use an Access database within ASP .NET, two things are required.
    First, the ASPNET user needs permission to read/write to the database
    (assuming you are including insert, delete, or update ability. Second, the
    ASPNET users needs to be able to create a file within the application folder
    because Access create a new file to manage locking.

    Please see:

    http://www.asp.net/security.aspx?tabindex=0&tabid=1

    for complete details.

    bill burrows

    "ptreves" <ptreves@sympatico.ca> wrote in message
    news:56C2E2ED-585B-46C0-98E2-1F7A12F26F1A@microsoft.com...
    > Hello,
    >
    > I am writing an ASP.NET application and accessing a MS-Access DB.
    > I get the following error
    > The Microsoft Jet database engine cannot open the file 'C:\My
    Folder\CI211 - C#\Final Project\Northwind_2.mdb'. It is already opened
    exclusively by another user, or you need permission to view its data.]
    >
    > How can I resolve this problem ?
    >
    > I heard that I should enable impersonation of my ASP.NET application. What
    is all that about ?
    >
    > Regards,
    >
    > Paolo
    >


  • Next message: ptreves: "Re: DB connection PB."

    Relevant Pages

    • Concurrency Violation in DataSet Update ADO.NET
      ... Now I am developing Cheque Writing ... 'UPDATE DATABASE ... "TBKKTC") ... I use password to protect my Access database from ...
      (microsoft.public.dotnet.general)
    • Re: formatting columns
      ... This works for columns either to the left or right of the cell to be copied. ... >> I am preparing to set up a database in Access2002. ... >> have the time to set up the Access database so I must do ... >> my data entry into Excel. ...
      (microsoft.public.excel.worksheet.functions)
    • Re: Web Wiz Forums in New Subweb, Published with FP2003
      ... Whenever I download an Access database and prior to re-uploading I always do a compact and repair ... General rule once your forum is active, you should never download and then re-upload the ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
      (microsoft.public.frontpage.client)
    • Re: Failure of Linked table in Access...
      ... SQL Server database via an ODBC DSN. ... in the Access database with various forms and reports. ... error and all subsequent queries on the PROJ table fail. ... The table is one of many tables that are linked from SQL Server ...
      (microsoft.public.access.modulesdaovba)
    • ~~~~~~~~~~~~~~ WEB DATABASE ~~~~~~~~~~~~~~
      ... 2003 vb web database code ... access database and web hosting ... access database free web hosting ... add adventureworks database to web site ...
      (comp.protocols.snmp)