beginning asp/ado problem (80040e09)

[djc]

Microsoft JET Database Engine error '80040e09'

Record(s) cannot be read; no read permission on 'tblTest'.

/test/test.asp, line 46

I am just starting to mess with asp/ado. I have an access database with this
one table just to test and learn asp/ado. I get the error above when just
trying to read data from the table? I am connecting to it from my own
computer's IIS installation. (winxp pro). I have anonymous access disabled
and I have digest and integrated windows authentication enabled. So going
from my own machine to my own machine I assume I am using integrated windows
authentication. I am positive ALL NTFS permissions for myself are good.

Why this error? I can open the file in access and access the table with no
problem. Just not through the browser and asp/ado.

The iis directory permissions are set to read and write and the execute
permission is set to 'scripts only'.

anyone know whats wrong?

[Ray at]

What does your connection string look like? If you're passing a username
and password in your connection string, get rid of them, unless you have
established users in your Access database itself.

Ray at home

"djc" <noone@nowhere.com> wrote in message
news:ONloKw2kDHA.1004@TK2MSFTNGP09.phx.gbl...

> Microsoft JET Database Engine error '80040e09'
>
> Record(s) cannot be read; no read permission on 'tblTest'.
>
> /test/test.asp, line 46
>
> I am just starting to mess with asp/ado. I have an access database with

this

> one table just to test and learn asp/ado. I get the error above when just
> trying to read data from the table? I am connecting to it from my own
> computer's IIS installation. (winxp pro). I have anonymous access disabled
> and I have digest and integrated windows authentication enabled. So going
> from my own machine to my own machine I assume I am using integrated

windows

> authentication. I am positive ALL NTFS permissions for myself are good.
>
> Why this error? I can open the file in access and access the table with no
> problem. Just not through the browser and asp/ado.
>
> The iis directory permissions are set to read and write and the execute
> permission is set to 'scripts only'.
>
> anyone know whats wrong?
>
>

[Ken Schaefer]

This appears to be a problem *inside* the database, not an NTFS permissions
problem or similar.

Have you setup users and groups inside the Access database? If so, then
you'll need to append the appropriate username/password to your connection
string.

Cheers
Ken

"djc" <noone@nowhere.com> wrote in message
news:ONloKw2kDHA.1004@TK2MSFTNGP09.phx.gbl...
: Microsoft JET Database Engine error '80040e09'
:
: Record(s) cannot be read; no read permission on 'tblTest'.
:
: /test/test.asp, line 46
:
: I am just starting to mess with asp/ado. I have an access database with
this
: one table just to test and learn asp/ado. I get the error above when just
: trying to read data from the table? I am connecting to it from my own
: computer's IIS installation. (winxp pro). I have anonymous access disabled
: and I have digest and integrated windows authentication enabled. So going
: from my own machine to my own machine I assume I am using integrated
windows
: authentication. I am positive ALL NTFS permissions for myself are good.
:
: Why this error? I can open the file in access and access the table with no
: problem. Just not through the browser and asp/ado.
:
: The iis directory permissions are set to read and write and the execute
: permission is set to 'scripts only'.
:
: anyone know whats wrong?
:
:

[djc]

hmm. Well we do have a production access database here that uses the access
security workgroup setup (mdw file). My machine was setup to use this file
and I was authenticated agianst it when I created the 'test.mdb' file to
use. After I encountered this problem that was the first thing I wanted to
find out. Was this problem cause *in* the database or *in* the OS/IIS. So I
disjoined the access workgroup file. I still have the same problem but
agian, I did belong to this workgroup *when* I created the test.mdb file.??

This brings up a very important point for me. Since the whole reason I am
learning asp/ado now is to eventually use it in production here and we
*already* have a production access database and *everyone* belongs to this
mdw workgroup file, how will this work? Do I have to send credentials in the
connection string? Isn't that a bad thing?

and of course how do I go about verifying that this is indeed my current
problem?

Thanks for the reply.


"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
news:OSCHCZ4kDHA.684@TK2MSFTNGP09.phx.gbl...

> This appears to be a problem *inside* the database, not an NTFS

permissions

> problem or similar.
>
> Have you setup users and groups inside the Access database? If so, then
> you'll need to append the appropriate username/password to your connection
> string.
>
> Cheers
> Ken
>
> "djc" <noone@nowhere.com> wrote in message
> news:ONloKw2kDHA.1004@TK2MSFTNGP09.phx.gbl...
> : Microsoft JET Database Engine error '80040e09'
> :
> : Record(s) cannot be read; no read permission on 'tblTest'.
> :
> : /test/test.asp, line 46
> :
> : I am just starting to mess with asp/ado. I have an access database with
> this
> : one table just to test and learn asp/ado. I get the error above when

just

> : trying to read data from the table? I am connecting to it from my own
> : computer's IIS installation. (winxp pro). I have anonymous access

disabled

> : and I have digest and integrated windows authentication enabled. So

going

> : from my own machine to my own machine I assume I am using integrated
> windows
> : authentication. I am positive ALL NTFS permissions for myself are good.
> :
> : Why this error? I can open the file in access and access the table with

no

> : problem. Just not through the browser and asp/ado.
> :
> : The iis directory permissions are set to read and write and the execute
> : permission is set to 'scripts only'.
> :
> : anyone know whats wrong?
> :
> :
>
>

[djc]

hmm. Well we do have a production access database here that uses the access
security workgroup setup (mdw file). My machine was setup to use this file
and I was authenticated agianst it when I created the 'test.mdb' file to
use. After I encountered this problem that was the first thing I wanted to
find out. Was this problem cause *in* the database or *in* the OS/IIS. So I
disjoined the access workgroup file. I still have the same problem but
agian, I did belong to this workgroup *when* I created the test.mdb file.??

This brings up a very important point for me. Since the whole reason I am
learning asp/ado now is to eventually use it in production here and we
*already* have a production access database and *everyone* belongs to this
mdw workgroup file, how will this work? Do I have to send credentials in the
connection string? Isn't that a bad thing?

and of course how do I go about verifying that this is indeed my current
problem?

Thanks for the reply.

"Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
news:uNqXcW4kDHA.2456@TK2MSFTNGP09.phx.gbl...

> What does your connection string look like? If you're passing a username
> and password in your connection string, get rid of them, unless you have
> established users in your Access database itself.
>
> Ray at home
>
> "djc" <noone@nowhere.com> wrote in message
> news:ONloKw2kDHA.1004@TK2MSFTNGP09.phx.gbl...

> > Microsoft JET Database Engine error '80040e09'
> >
> > Record(s) cannot be read; no read permission on 'tblTest'.
> >
> > /test/test.asp, line 46
> >
> > I am just starting to mess with asp/ado. I have an access database with

> this

> > one table just to test and learn asp/ado. I get the error above when

just

> > trying to read data from the table? I am connecting to it from my own
> > computer's IIS installation. (winxp pro). I have anonymous access

disabled

> > and I have digest and integrated windows authentication enabled. So

going

> > from my own machine to my own machine I assume I am using integrated

> windows

> > authentication. I am positive ALL NTFS permissions for myself are good.
> >
> > Why this error? I can open the file in access and access the table with

no

> > problem. Just not through the browser and asp/ado.
> >
> > The iis directory permissions are set to read and write and the execute
> > permission is set to 'scripts only'.
> >
> > anyone know whats wrong?
> >
> >

>
>