2007 Runtime and Linked Table Manager

[Damon Heron]

I have asked this question before, with no response. I have a 2003 db that
has a custom menu created in 2003.
When I create a runtime version with 2007 and install it on a PC without
Access 2007 installed, all works fine,
with the exception of one of my menu items:
Linked Table Manager, under Tools.
When the user clicks on the word Tools, the db crashes. This only happens
with the runtime version,
so I am guessing that it cannot find the Linked Table Manager.
Anyone have any idea how I can add this wizard to a runtime version?

Damon

 

[AnandaSim]

I have asked this question before, with no response. I have a 2003 db that
has a custom menu created in 2003.

Ok, I'll help.

I can guess that the Wizards (like the Linked Table Manager) are not
approved by Microsoft for distribution with runtime (this I remember
from old Access versions).

You have to create your own auto-linking VBA code - there should be a
sample in Access 2003 Northwind. Also on Access Web MVP website(?)

Or you can pre-link the .mdb and distribute the .mdb - you don't need
to link each .mdb separately on every single machine.

HTH
Ananda

 

[Tony Toews [MVP]]

Also on Access Web MVP website(?)

Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm

I store the path in an INI file in the same folder as the FE. If a
linked table to the BE doesn't open then I look in that INI file for
the last known location and relink to it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Damon Heron]

Thanks to both of you for your help. I will try it via code.

Damon