[AccessD] Open Linked Table Manager from code

It was an add-in in 97 and earlier but in 2000 and later it is part of the database utilities.

Charlotte Foust

-----Original Message-----
From: Jürgen Welz [mailto:jwelz at hotmail.com] 
Sent: Tuesday, May 25, 2004 3:09 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Open Linked Table Manager from code


The linked table manager is an add-in that, in my experience, is not 
installed by default in 97 and 2000 versions.  I have yet to work in an 
envrionment where this add-in was available when I walked in the door so the 
DoMenuItem and RunCommand approaches have been of little use.  You will be 
better served in the long run to set the connect property of a tabledef 
object and then call the refreshlink method of that tabledef object.  This 
is especially true if your users may be in unknown environments.  Rolling 
your own relinking code is not difficult and allows you to simplify the 
procedure for users by stipulating which tables may be relinked without 
asking the users to make selections.  User 'interference' can get really 
ugly if you have multiple backend files of varying types in various 
locations where some may be ISAM, others ODBC and yet others native Access 
files.

Ciao
Jürgen Welz
Edmonton, Alberta
jwelz at hotmail.com





>From: "Mackin, Christopher" <CMackin at quiznos.com>
>
>docmd.RunCommand acCmdLinkedTableManager
>
>Will do it
>
>-Chris Mackin
>
>-----Original Message-----
>From: Paul Baumann [mailto:Paul.Baumann at rtctech.com]
>Sent: Tuesday, May 25, 2004 3:54 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Open Linked Table Manager from code
>
>
>Is there any way to open the Linked Table Manager from code?
>
>Paul Baumann

_________________________________________________________________
Free yourself from those irritating pop-up ads with MSn Premium. Get 2months 
FREE*  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com