Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / February 2007

Tip: Looking for answers? Try searching our database.

Linked Table Manager inavailability

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Charles Tam - 06 May 2005 19:24 GMT
Is it correct that the Linked Table Manager is disabled when the user's login
does not have local machine administrative rights?  

If so, is there any alternatives to relink tables on non administrative
accounts?
'69 Camaro - 06 May 2005 20:30 GMT
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 Ripley@CASInternet.Net and scott@ripleysoftware.com

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

> Is it correct that the Linked Table Manager is disabled when the user's login
> does not have local machine administrative rights?  
>
> If so, is there any alternatives to relink tables on non administrative
> accounts?
Cynthia - 01 Feb 2007 18:19 GMT
How can I take away the linked table ability?  I have a db linked to SQL and
have found a users can start a new db and then link to this table and have
complete access.

> Hi, Charles.
>
[quoted text clipped - 68 lines]
> > If so, is there any alternatives to relink tables on non administrative
> > accounts?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.