Refreshing tables

[W. Guy Delaney]

I have a client in another state whose database I designed and administer
when the normal administrator is on vacation or can't solve a problem. The
database is transferred to the client by FTP. I just added user/group level
security to that database, split it into a frontend and backend, and sent it
to my client. I discovered that, in order to use the Link Table Manager,
the client needs full permissions on all the tables. Since the normal
Administrator is on vacation for three more weeks, is there a way to link
the tables without giving full permissions?

 

[Graham Mandeno]

Hi Guy

There is actially no harm in giving full permissions to the attached tables
in the front-end, so long as the tables in the back-end have the appropriate
permissions. Access uses a "most restrictive" algorithm to determing
permissions on attached (linked) tables, so the data is still safe.

I suggest you investigate writing VBA code to relink the tables, as this
will be far more robust and secure than allowing the users to use the Linked
Table Manager. Also, the LTM uses the RefreshLink method to relink tables,
and this required ReadData permissions on all the back-end tables, which
might not be appropriate for your application.

Finally, have you read the Access Security FAQ? If not, then I *strongly*
recommend
you download it from: http://support.microsoft.com/?id=207793

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.