ODBC Linked Table Security

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 03 Sep 2004 15:50 GMT

I created a report based from a query from an ODBC linked
table to an AS/400 query through client access. Users
cannot run the report and they get a statement that the
ODBC connection failed. If I try to refresh the link, I
get a message that they do not have the appropriate
permissions. Anyone know what permissions need changes?
The users have the rights to the folder where the front
and back ends are stored and rights to sign on to the
AS/400.

Reply to this Message

Rick Brandt - 03 Sep 2004 23:59 GMT

> I created a report based from a query from an ODBC linked
> table to an AS/400 query through client access. Users
[quoted text clipped - 5 lines]
> and back ends are stored and rights to sign on to the
> AS/400.

Do they have at least *USE authority on the particular AS400 table and all of
its indexes and Logical Files? Access will try to use all of these when you
create a link.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message