Reattaching MS Access tables after moving to DASP

Discussion in 'Databases' started by Scott, Jan 4, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Scott

    Scott

    Consider this scenario: main.mdb, a.mdb, and b.mdb are MS Access databases which reside in the same directory. The a.mdb and b.mdb databases both link to a table in main.mdb.

    When the databases are moved to the DASP server, the links are "broken" because the directory path that was stored for the link when it was created on the local host does not exist on the DASP servers.

    Is there a way to recreate the links once the databases are moved to the server? Can anyone point me in the right direction?

    Thanks,
    Scott
     
    Scott, Jan 4, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    i think you'll have to recreate the link

    quote:Originally posted by Scott

    Consider this scenario: main.mdb, a.mdb, and b.mdb are MS Access databases which reside in the same directory. The a.mdb and b.mdb databases both link to a table in main.mdb.

    When the databases are moved to the DASP server, the links are "broken" because the directory path that was stored for the link when it was created on the local host does not exist on the DASP servers.

    Is there a way to recreate the links once the databases are moved to the server? Can anyone point me in the right direction?

    Thanks,
    Scott

    </blockquote id="quote"></font id="quote">
     
    Bruce, Jan 4, 2004
    #2
  3. Scott

    Scott

    Yes, I agree. I do have to recreate the link(s). <u>My question is how?</u> I was unable to find an answer in Access help, on MSDN, in the knowledge base, or by Googling.

    Scott

     
    Scott, Jan 4, 2004
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page