Hi, Charles.
Is it correct that the Linked Table Manager is disabled when the user's login
does not have local machine administrative rights?
No. It means that the Windows system administrator threw the baby out with
the bath water, proclaiming it necessary "for security purposes." If the
workstation is properly configured, an ordinary user can use _all_ of the
features of Microsoft Office, including all of the Access Wizards. Windows
Administrator or Power User permissions are not a prerequisite for the Linked
Table Manager.
Have the Windows system administrator ensure that all Windows users can
read, write, create, and delete files in the Microsoft Office directory on
the workstation. The default directory is"
C:\Program Files\Microsoft Office\OFFICE<Version#>"
Windows users also need Windows read file security permissions for the DAO,
ADO and VBA libraries. Default directories are:
C:\Program Files\Common Files\Microsoft Shared\DAO
C:\Program Files\Common Files\System (and subdirectories)
C:\Program Files\Common Files\Microsoft Shared\VBA (and subdirectories)
Depending upon the version of Access and the Windows operating system, there
may be other directories that the user needs Windows read, write, and delete
security permissions, too. These would be the Windows user's temp directory
and Windows profile directory, so the default directories vary. If using
Access 97, then the Windows user needs these Windows security permissions for
the C:\WINDOWS\system32 directory, also.
Without these Windows security permissions, the Windows user will have
limited capabilities with the Microsoft Office applications, including the
inability to use the Access Wizards and Access user-level security.
If so, is there any alternatives to relink tables on non administrative
accounts?
Please see the code to relink tables on the following Web page:
http://www.mvps.org/access/tables/tbl0009.htm
The user must have Access user-level Read Design security permissions on
these tables in the database back end, as well as Access user-level security
permissions to create new tables in the current database.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
