Results 1 to 3 of 3
  1. #1
    bdaniel is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    44

    VBA to automatically re-link back end tables

    After splitting my database, when I copy the database to a new directory the link to the back end tables is lost. Easy enough to re-link using the Linked Table Manager.



    Want to distribute to users who will install on there own computer or server and would like to know if anyone can provide code to automatically link, or provide an input window for user enter the location of the back end to re-link.

    thanks.

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Check out the J-Street Access Relinker here:
    http://www.jstreettech.com/cartgenie...rDownloads.asp

  3. #3
    bdaniel is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    44
    Thanks Bob. Downloaded the .mdb file and see the macros and VBA module.

    Will incorporate into my program and see how it works. Lots of code I can go through and learn some things as well.

    Thanks again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. how to link 3 tables?
    By handsome1855 in forum Access
    Replies: 1
    Last Post: 03-10-2011, 09:25 AM
  2. Front end link to back end
    By Melo in forum Security
    Replies: 4
    Last Post: 01-21-2011, 09:25 PM
  3. auto link between front db and back db
    By ahmed in forum Programming
    Replies: 3
    Last Post: 08-09-2010, 07:10 AM
  4. One-way link between tables
    By Mikele di Sagitter in forum Database Design
    Replies: 1
    Last Post: 07-23-2010, 08:26 AM
  5. Replies: 7
    Last Post: 05-15-2010, 10:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums