ODBC Linked Table Security

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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.
 
Paul said:
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.
Click to expand...

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.
 
Back
Top