dcsimg
Results 1 to 2 of 2

Thread: Linking tables to two back ends

  1. #1
    Join Date
    Jun 2010
    Location
    Kansas, USA
    Posts
    15

    Linking tables to two back ends

    Hello, I was wondering if something was possible in access. I have inherited a database that has multiple back ends. All back ends feed into another database where the pooled information is collected. What I would like to do is have two tables. One where the back locations are set Example:

    Pittsburgh \\steel\database\PittBE.mdb
    Canada \\leaf\database\CanBE.mdb

    One with the linked table names that will need to be linked. Example:

    tblCategories
    tblSubcategories

    I want the user to be able to select on a combo box, their location and update the links to the appropriate location. However I want to have some of the tables in the front end to be linked to the pooled database. These would be tblProjects, tblAssociates, tblPositions

    any help would be appreciated, or maybe there is a better way to do this then the one I have proposed.

    Thanks

  2. #2
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •