backend table permission

[Richardson]

Since I have received such great advice from this group in the past, here
goes another question.
In my database (Access 2002) the first form after the splash is a form for
the user to choose between 4 different backend locations. The database then
refreshes the links to those tables.
The problem is that all users and groups need to be able to do this refresh,
but it seems they are unable to use the RefreshLink command unless they have
adminster privleges on the tables. I really don't want to give them that
kind of permission for the tables.
Does anyone have a suggestion?

Lori

 

[Joan Wild]

That's not been my experience. You can give users full permissions on the
links in the frontend - they'll still be restricted to the permissions they
have on the backend tables.

Where do they need administer permission?

 

[Richardson]

The code that refreshes the links seems to require it. I have tried running
the code without adminster permission and it fails. It works only when
administer permission is granted on the front end. I am still able to
restrict their access on the backend. I am going strictly on the experience
I have had with it, so there may be another workaround.

Lori

 

[Joan Wild]

Please specify, administer permission on what object - the database, the
tables, the links???

Administer permissions are not required to refresh - see the security FAQ.
It even outlines how to link with no permissions