2010 Links to 2003 MDBs

Posted on 2012-08-17
Last Modified: 2012-08-22
I am converting a large group of Access 2000/2003 .mdb files to 2007/2010 .accdb. Some of the converted files have links to other .mdbs. Eventually all will be on 2007/2010 but during the conversion we would prefer to be able to maintain the links from the .accdb files to the .mdb tables until we finish the conversion.

Will the links from an .accdb file to an .mdb file continue to work?

Question by:Buck_Beasom
    LVL 65

    Expert Comment

    by:Jim Horn
    You'll have to change all the links from this format:

    "path of Access file"

    to this format

    "path of correct Acccess app.exe" "path of Access file"

    and if it asks you for the workgroup (security) file

    "path of correct Acccess app.exe" "path of Access file" /wrkgrp "path of .mdw file"

    Author Comment

    Where do I do this? The links were done using the Linked Table Manager, and that just asks you to locate the folder and file where the .mdb holding the linked tables are.

    LVL 65

    Expert Comment

    by:Jim Horn
    Disregard my first comment.  I interpreted 'links' as URL's, and not linked tables.

    Have you tested this to verify that an Access 2010 app can/can not have a linked table to an Access 2003 app?  I don't have any experience with this, but off the top of my head I would guess that linked tables are backwards compatible.
    LVL 77

    Accepted Solution

    There is nothing obvious in your post to suggest the applications would not continue to work as normal.

    But you have to test each one as you convert the frontend.  It is the detail of each application that will matter in the end and obviously it is possible that an existing app uses something 'non-standard' that doesn't convert.

    Author Closing Comment


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now