Trouble accessing the MS Access 'MSysObjects' system table through an ASP page

[Marshal]

Earlier on this board, I got a solution from Ray (thanks
again) on how to run a querry to see if a table exists
and it works fine in Access. But when I try to run it
through an ASP page I get this permissions error:

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

I know I've got read permissions to the DB itself so I'm
not sure what I'm missing here. Any ideas?

Thanks

[Ray at]

Are you passing login credentials to your Access database? If so:

Try opening the Access database in Access, and then do:

Tools--Security---User and Group Permissions...
Select the MSysObjects in the objects list, and give read data permissions
to <the user setup in the database that you use in your connection string>.

Ray at work

"Marshal" <marshalwdr@hotmail.com> wrote in message
news:1f4fc01c389d5$9a95e520$a601280a@phx.gbl...

> Earlier on this board, I got a solution from Ray (thanks
> again) on how to run a querry to see if a table exists
> and it works fine in Access. But when I try to run it
> through an ASP page I get this permissions error:
>
> "Record(s) cannot be read; no read permission
> on 'MSysObjects'."
>
> I know I've got read permissions to the DB itself so I'm
> not sure what I'm missing here. Any ideas?
>
> Thanks
>
>

[Marshal]

No, we have login credentials to the site but we don't
pass them to the database.

>-----Original Message-----
>Are you passing login credentials to your Access

database? If so:

>
>Try opening the Access database in Access, and then do:
>
>Tools--Security---User and Group Permissions...
>Select the MSysObjects in the objects list, and give

read data permissions

>to <the user setup in the database that you use in your

connection string>.

>
>Ray at work
>
>"Marshal" <marshalwdr@hotmail.com> wrote in message
>news:1f4fc01c389d5$9a95e520$a601280a@phx.gbl...

>> Earlier on this board, I got a solution from Ray

(thanks

>> again) on how to run a querry to see if a table exists
>> and it works fine in Access. But when I try to run it
>> through an ASP page I get this permissions error:
>>
>> "Record(s) cannot be read; no read permission
>> on 'MSysObjects'."
>>
>> I know I've got read permissions to the DB itself so

I'm

>> not sure what I'm missing here. Any ideas?
>>
>> Thanks
>>
>>

>
>
>.
>

[Ray at]

Then open up the DB and verify that all users have access to that table.

Ray at work

"Marshal" <marshalwdr@hotmail.com> wrote in message
news:1f5c701c389df$8834cd60$a601280a@phx.gbl...

> No, we have login credentials to the site but we don't
> pass them to the database.
>
>
>

> >-----Original Message-----
> >Are you passing login credentials to your Access

> database? If so:

> >
> >Try opening the Access database in Access, and then do:
> >
> >Tools--Security---User and Group Permissions...
> >Select the MSysObjects in the objects list, and give

> read data permissions

> >to <the user setup in the database that you use in your

> connection string>.

> >
> >Ray at work
> >
> >"Marshal" <marshalwdr@hotmail.com> wrote in message
> >news:1f4fc01c389d5$9a95e520$a601280a@phx.gbl...

> >> Earlier on this board, I got a solution from Ray

> (thanks

> >> again) on how to run a querry to see if a table exists
> >> and it works fine in Access. But when I try to run it
> >> through an ASP page I get this permissions error:
> >>
> >> "Record(s) cannot be read; no read permission
> >> on 'MSysObjects'."
> >>
> >> I know I've got read permissions to the DB itself so

> I'm

> >> not sure what I'm missing here. Any ideas?
> >>
> >> Thanks
> >>
> >>

> >
> >
> >.
> >