If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2007 Runtime and Linked Table Manager
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 |
#2
|
|||
|
|||
2007 Runtime and Linked Table Manager
On Sep 16, 4:20 am, "Damon Heron" wrote:
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 |
#3
|
|||
|
|||
2007 Runtime and Linked Table Manager
AnandaSim wrote:
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/ |
#4
|
|||
|
|||
2007 Runtime and Linked Table Manager
Thanks to both of you for your help. I will try it via code.
Damon "Tony Toews [MVP]" wrote in message ... AnandaSim wrote: 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/ |
Thread Tools | |
Display Modes | |
|
|