Re: Problem accessing Access DB through ASP

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 10/30/04

  • Next message: RB: "Re: docmd.transfertext" 
    Date: Sat, 30 Oct 2004 05:47:22 -0400

    ASP pages typically run under the IUSR_<machinename> User ID. Does that ID
    have Change access (Read, Write, eXecute and Delete) to the folder where the
    MDB file exists? 

    -- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Harry" <Harry@discussions.microsoft.com> wrote in message
news:91FB874F-1535-4E31-A337-D922A430B3C9@microsoft.com...
> Hi
>
> I have a MS-Access 97 and IIS installed on my Win 2000 server. I have an
> Analysis Software which analysis the composition of the clinker and other
raw
> material that are used in our company. I wanted some reports out of the
data
> that the analysis software database so i made a new database that is
> basically a link to the analysis databases that also are Access 97
databases.
> So now I have made the cross-tabbed reports but I want the access anywhere
on
> my intranet. So tried to access the pages through a simple ASP pages which
> basically run the queries that my reports in access uses. But now here is
the
> problem I am not able to access the database through the ASP pages it
gives
> me error "Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
> [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no
read
> permission on 'SampleTable'.
> /Analysis/test.asp, line 25"
> This SampleTable is there in the linked table of my database. I have done
> everything from changing the permissions of my database and the base
database
> but of no use.
>
> If anyone can help me out with this permissions problem i would be
greatful
>
> Cheers
>
> Harry
  • Next message: RB: "Re: docmd.transfertext"

    Relevant Pages

    • Re: Access97 DB locks up the asp code at times
      ... of these users created the query off the asp and that's the problem. ... but I could never see the employee.ldb on the folder ... I'll chat with our IT group about setting the proper permissions. ... All database users, including the IUSR_MachineName account, need ...
      (microsoft.public.inetserver.asp.general)
    • Re: My database wont work.
      ... Ive sorted out the permissions and stuff and ive had the database ... > diplaying as asp properly. ... >>> My Database is stored in the wwwroot directory as it should be. ... >>> ADO Include inside the asp aswell. ...
      (microsoft.public.inetserver.asp.db)
    • IIS, ASP, and MS Access
      ... I know the temporary fix to this problem, ... other files and folders required for the ASP app. ... Access db and you get error: "The MS Jet database engine ... Go back and reset up the IUSR account permissions as ...
      (microsoft.public.inetserver.iis.security)
    • Re: My database wont work.
      ... Ive sorted out the permissions and stuff and ive had the database ... diplaying as asp properly. ... >> My Database is stored in the wwwroot directory as it should be. ... >> ADO Include inside the asp aswell. ...
      (microsoft.public.inetserver.asp.db)
    • Re: Validate logins with ASP, MS Access and Cookies error
      ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
      (microsoft.public.inetserver.asp.db)
    Loading