none
Re-Link Tables to An Access 2003 Application

    Question

  • Hello - 

    Access 2003, Vista

    How do I define the linked tables to the location of the application ?

    I want that where ever the application is in, it will location the linked tables be searching it in the application path

    Thanks

    Alu

    Thursday, May 19, 2011 12:25 PM

Answers

  • Are the tables all Access tables?  If so, you might want to try the Jstreet relinker.  I believe it will relink for you.

    Armen Stein J-Street Solution
    Database relinker

    http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

    Here is the Access table relinking VBA module that J Street has used in all of our Access applications for years. It is an essential enhancement after you have split your database into a front-end application and a back-end database. It handles multiple back-end Access databases, checks your linked tables on startup, prompts your user to locate the back-end database if needed, and even has an automatic mode that silently relinks to local databases (great for work tables and single user scenarios). NEW VERSION Feb 2011 — Automatically ignores all non-Access linked tables, including SharePoint lists. Access 2000/XP/2003/2007/2010

    If your tables are not in Access, then post back with information about your table source(s).


    John Spencer Access MVP 2002-2005, 2007-2011 The Hilltop Institute University of Maryland Baltimore County
    • Marked as answer by Bruce Song Friday, May 27, 2011 12:28 PM
    Thursday, May 19, 2011 1:06 PM
  • Thanks John.  Yes, our J Street Access Relinker has a CheckAppFolder
    option that will automatically and silently relink any Access back-end
    databases found in the same folder as the application file.
     
    A shorter link is:  www.JStreetTech.com/downloads
     
    Cheers,
     
    Armen Stein
    Microsoft Access MVP
    www.JStreetTech.com
     
     
    • Marked as answer by Bruce Song Friday, May 27, 2011 12:28 PM
    Thursday, May 19, 2011 2:55 PM

All replies

  • Are the tables all Access tables?  If so, you might want to try the Jstreet relinker.  I believe it will relink for you.

    Armen Stein J-Street Solution
    Database relinker

    http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

    Here is the Access table relinking VBA module that J Street has used in all of our Access applications for years. It is an essential enhancement after you have split your database into a front-end application and a back-end database. It handles multiple back-end Access databases, checks your linked tables on startup, prompts your user to locate the back-end database if needed, and even has an automatic mode that silently relinks to local databases (great for work tables and single user scenarios). NEW VERSION Feb 2011 — Automatically ignores all non-Access linked tables, including SharePoint lists. Access 2000/XP/2003/2007/2010

    If your tables are not in Access, then post back with information about your table source(s).


    John Spencer Access MVP 2002-2005, 2007-2011 The Hilltop Institute University of Maryland Baltimore County
    • Marked as answer by Bruce Song Friday, May 27, 2011 12:28 PM
    Thursday, May 19, 2011 1:06 PM
  • Thanks John.  Yes, our J Street Access Relinker has a CheckAppFolder
    option that will automatically and silently relink any Access back-end
    databases found in the same folder as the application file.
     
    A shorter link is:  www.JStreetTech.com/downloads
     
    Cheers,
     
    Armen Stein
    Microsoft Access MVP
    www.JStreetTech.com
     
     
    • Marked as answer by Bruce Song Friday, May 27, 2011 12:28 PM
    Thursday, May 19, 2011 2:55 PM