ODBC Linked Table Security

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.
 
R

Rick Brandt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Security in Access 2013 1
Link to ODBC source with different DSN names 0
split data base using ODBC connection 1
Total parameter query and ODBC-call failed 0
Linking to Oracle 5
ODBC Failure, error 18456 1
OLE DB or ODBC real time connection 3
ODBC Linked Table Security 0

Top