Linked Tbl Mgr behavior

Discussion in 'Access Table Design' started by Russ, Dec 20, 2010.

  1. Russ

    Russ Guest

    When I want to link tables to the front end using the link tables
    manager it willl ask me to select the back end for each and every
    table wheras in prior versions of Access I only had to make this
    choice once if I checked the box "always prompt for new location".
    This is tedious. I'm using Access 2007 Enterprise version.
    Russ, Dec 20, 2010
    1. Advertisements

  2. I've seen this happen if the links aren't all to the same backend. Yes, it's a
    pain! What I'll sometimes do is just delete all the links in the frontend, and
    use External Data... Link to create new links.

    If all of the linked tables have links to the same backend, this (usually)
    isn't necessary.


    John W. Vinson [MVP]
    Microsoft's replacements for these newsgroups:
    and see also
    John W. Vinson, Dec 20, 2010
    1. Advertisements

  3. Russ

    Russ Guest

    I think that is it. I had a couple of testing backends and
    inadvertently one of the links was pointing to a table in a different
    db. It took me awhile to see it among all the table locations, but I
    finally got it going.
    Russ, Dec 20, 2010
  4. Russ

    Tony Toews Guest

    FWIW I now have code that on startup goes down the tabledefs and
    compares the connect string. If any differences it displays an error
    message along with the offending details.

    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages -
    Tony's Microsoft Access Blog -
    For a convenient utility to keep your users FEs and other files
    updated see
    Tony Toews, Dec 21, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.