Re: Problem with database connection

From: Jack (Jack_at_discussions.microsoft.com)
Date: 03/10/05 

Date: Thu, 10 Mar 2005 12:57:07 -0800

Thanks for your help Bob.
The database attached to the web application was a read-only one. So I
changed it. The IUSR_machinename permission is now read, write and and read
and execute. However, I did not find anything named Change Permission. I
found full control, modify and special permission.

With that I am still getting error.

The error message I quoted earlier was incorrect.The correct error message
was:
Error Type:
Microsoft JET Database Engine (0x80040E09)
Record(s) cannot be read; no read permission on 'tblPOSTApplicant'.
/mbcc/post/transcripts/CheckLogon.asp, line 65
Now, what else can go wrong here. Thanks. Regards.

"Bob Barrows [MVP]" wrote:

> Jack wrote:
> > Hi,
> > I got a web application which was connected to Access97 database.
> > However, few months back someone converted the database to Access
> > 2000. This database is uploaded on a monthly basis from client server
> > production Access97 database. Now, when I am uploading the Access97
> > database, there is a problem in connecting to the web application.
> > The error is as following:
> > Microsoft OLE DB Provider for ODBC Drivers.error '80040e09'
> > [Microsoft][ODBC Microsoft Access Driver] Records cannot be read; no
> > read permission on 'tblPOSTApplicant'.
>
> After verifying that the file's read-only attribute is off, check the IUSR
> account permissions for the folder containing the file - the account should
> have Change permissions. Then verify that the permissions hwve been
> inherited by the database file.
> >
> > The connection string where the error pops up is as follows:
> >
> > <%
> > myDSN="Provider=Microsoft.Jet.OLEDB.4.0;" & _
> > "Data
> > Source=C:\Inetpub\wwwroot\MBCC\post\Transcripts\data\postdata.mdb"
>
> ???? That can't be correct. You are getting an error from the "ODBC
> Microsoft Access Driver", not from the "OLE DB Provider for Microsoft Jet".
> Verify that the connection string you think is being used is in fact being
> used.
>
>
> Bob Barrows
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
>

Relevant Pages

  • Re: ASP page and SQL server error
    ... It's not the account, it's the priveleges that the account has with regards ... SQL Server permissions are very granular. ... while the user has permission to USE the database (in a general ...
    (microsoft.public.frontpage.programming)
  • Re: ASP.NET Website Project
    ... following sql exception: ... That is a *SQL Server* permission problem, not an ASP.NET or an IIS web server problem. ... You need to make sure that the account which you are using to access ... the database has read/write/change permissions for the database's objects. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problem running local asp.net app with web site on network share
    ... Actually, the cause for the error message is in Windows XP, ASP.NET ... Since it is only a local account, ... computer as one account to the UNC folder. ... permission. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Problem deserializing file from asp.net
    ... I gave the file write permission and it works. ... should write out an error message, ... > As for the file permissions you need to give the ASPNET account write access ... >> web service. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: 2007 wont open older format database
    ... The database is a 2000 format ... (which is overridden by using that shortcut with the secure workgroup command ... permission if the db is secure. ... Find out what the actual error message is when she tries to open the db.. ...
    (comp.databases.ms-access)