Hi All-

I just created a new Access database which requires all users to login.  
The old database did not require a login.  However, when i tried to run 
any asp scripts on the data in the new database, I keep receiving the 
error message "Record(s) cannot be read; no read permission".....I am 
using the script below.  This same script runs fine with the old 
database.  I am not sure what the problem is.  

Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")

objConn.open strConnect

objRS.Open "qHtmlEmailList", objConn, adOpenForwardOnly, adLockReadOnly, 
adCmdStoredProc

    
While not objRS.EOF
        email = objRS("email")
        Response.Write email
	objRS.MoveNext()
   Wend

    ObjRS.Close()
    ObjConn.Close()
    Set objRS = Nothing
    Set objConn = Nothing

Thanks,

Binu

How did you open your connection string?

----- Original Message -----
From: Binu <beanz75@a...>
To: Access ASP <access_asp@p...>
Sent: Wednesday, August 28, 2002 2:53 PM
Subject: [access_asp] Record(s) cannot be read; no read permission


> Hi All-
>
> I just created a new Access database which requires all users to login.
> The old database did not require a login.  However, when i tried to run
> any asp scripts on the data in the new database, I keep receiving the
> error message "Record(s) cannot be read; no read permission".....I am
> using the script below.  This same script runs fine with the old
> database.  I am not sure what the problem is.
>
> Set objConn = Server.CreateObject("ADODB.Connection")
> Set objRS = Server.CreateObject("ADODB.Recordset")
>
> objConn.open strConnect
>
> objRS.Open "qHtmlEmailList", objConn, adOpenForwardOnly, adLockReadOnly,
> adCmdStoredProc
>
>
> While not objRS.EOF
>         email = objRS("email")
>         Response.Write email
> objRS.MoveNext()
>    Wend
>
>     ObjRS.Close()
>     ObjConn.Close()
>     Set objRS = Nothing
>     Set objConn = Nothing
>
> Thanks,
>
> Binu
>

How did you open your connection string?

I opened my connection as this:  (this connection string works when 
connecting to the old access database; however, not the new one - it says 
i dont have read permissions).  The connection string is in a separate 
file and i call that file from my asp pages (SSI).

       <%
             strConnect = "Provider = Microsoft.Jet.OLEDB.4.0;" &_
             "Data Source= f:\test\Database\db1.mdb;" &_
             "Persist Security Info = False"
        %>

Thanks so much,

Binu

look if your db doesn't have password and user to access, else give "Total
Control" in your db folder ok?

Hugs, Daniel

----- Original Message -----
From: Binu <beanz75@a...>
To: Access ASP <access_asp@p...>
Sent: Wednesday, August 28, 2002 4:15 PM
Subject: [access_asp] Re: Record(s) cannot be read; no read permission


> How did you open your connection string?
>
> I opened my connection as this:  (this connection string works when
> connecting to the old access database; however, not the new one - it says
> i dont have read permissions).  The connection string is in a separate
> file and i call that file from my asp pages (SSI).
>
>        <%
>              strConnect = "Provider = Microsoft.Jet.OLEDB.4.0;" &_
>              "Data Source= f:\test\Database\db1.mdb;" &_
>              "Persist Security Info = False"
>         %>
>
> Thanks so much,
>
> Binu
>

open your access database, click on tools security usergroups and
permissions.

select the table for appropriate permissions and assign permissions
required.

----- Original Message -----
From: "Binu" <beanz75@a...>
To: "Access ASP" <access_asp@p...>
Sent: Wednesday, August 28, 2002 2:53 PM
Subject: [access_asp] Record(s) cannot be read; no read permission


> Hi All-
>
> I just created a new Access database which requires all users to login.
> The old database did not require a login.  However, when i tried to run
> any asp scripts on the data in the new database, I keep receiving the
> error message "Record(s) cannot be read; no read permission".....I am
> using the script below.  This same script runs fine with the old
> database.  I am not sure what the problem is.
>
> Set objConn = Server.CreateObject("ADODB.Connection")
> Set objRS = Server.CreateObject("ADODB.Recordset")
>
> objConn.open strConnect
>
> objRS.Open "qHtmlEmailList", objConn, adOpenForwardOnly, adLockReadOnly,
> adCmdStoredProc
>
>
> While not objRS.EOF
>         email = objRS("email")
>         Response.Write email
> objRS.MoveNext()
>    Wend
>
>     ObjRS.Close()
>     ObjConn.Close()
>     Set objRS = Nothing
>     Set objConn = Nothing
>
> Thanks,
>
> Binu
>

> Hi All-

> I just created a new Access database which requires all users to 
login.  
T> he old database did not require a login.  However, when i tried to run 
a> ny asp scripts on the data in the new database, I keep receiving the 
e> rror message "Record(s) cannot be read; no read permission".....I am 
u> sing the script below.  This same script runs fine with the old 
d> atabase.  I am not sure what the problem is.  

> Set objConn = Server.CreateObject("ADODB.Connection")
S> et objRS = Server.CreateObject("ADODB.Recordset")

> objConn.open strConnect

> objRS.Open "qHtmlEmailList", objConn, adOpenForwardOnly, 
adLockReadOnly, 
a> dCmdStoredProc

>     
W> hile not objRS.EOF
 >        email = objRS("email")
 >        Response.Write email
	> objRS.MoveNext()
 >   Wend

>     ObjRS.Close()
 >    ObjConn.Close()
 >    Set objRS = Nothing
 >    Set objConn = Nothing

> Thanks,

> Binu

Hi,
 I had this exact same problem with my database.. I actually ended up 
uninstalling Access and removing my access preferences from my aplication 
data folder. Then I reinstalled Access and everything seemed to work fine 
from there.. Nothing I tried seemed to work.. that was my last option..

I don't recommend doing it but it is always a last resort option..

Jeremy