General discussion

  • Creator
    Topic
  • #2316211

    MS ACCESS 2000

    Locked

    by flipjive ·

    I have an ACCESS database split into 2 files (interface and data files) where the tables are linked. How can I have the Interface file automatically link tables to the Data file, whenever the Data file pathway changes (w/out manually using the Linked Table Manager)?

All Comments

  • Author
    Replies
    • #3380155

      Reply To: MS ACCESS 2000

      by abarnes70 ·

      In reply to MS ACCESS 2000

      I’d use VBA code to reconnect the tables every time the database is opened, and disconnect them when closing the database. It’s a long time since I’ve written that sort of code, but if you need me to I can probably find some old stuff I’ve written in 97 that could be converted to 2000…

    • #3380149

      Reply To: MS ACCESS 2000

      by timfox ·

      In reply to MS ACCESS 2000

      Check out the following link for Dev Ashish’s site:
      http://www.mvps.org/access/tables/tbl0009.htm

      Hope it helps.
      Tim

Viewing 1 reply thread