Results 1 to 5 of 5

Connecting split databases in separate directories

  1. #1
    skyrat is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2018
    Posts
    19

    Question Connecting split databases in separate directories

    Problem : 1 Admin.mdb with tables tblPers, tblBook and other tables split into 2 connected databases Admin.mdb (containing tblPers and all other tables except tblBook) and Data.mdb (containing tblBook).
    Queries in Admin.mdb automaticly use tables from Data.mdb. So far so good.


    To try out some changes in Admin.mdb I created a new Directory Direc2 and copied both databases from Direc1 to Direc2. Now in Direc2 a query in Admin.mdb that uses tblPers and tblBook updates tblBoek IN DIREC1 and NOT IN DIREC2 !!
    So there is still a relation between Direc2\Admin.mdb and Direc1\Data.mdb
    How can I let Direc2\Admin.mdb only use Direc2\Data.mdb ?

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    377
    Have you tried the Linked Table manager?
    One helpful tool to have is the J Street Relinker...https://www.jstreettech.com/downloads.aspx

  3. #3
    skyrat is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2018
    Posts
    19
    I have a Dutch version of Access, but I'll try to find some translation for "Linked Table manager". So far I can only find something to connect tables within the same database !

    I believe I found the solution in : "Externe gegevens" --> "Koppelingsbeheer" at the bottom you can check "Altijd om nieuwe locatie vragen"

    thanks for your tip !!

  4. #4
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    377
    Not that I understand Dutch, but that looks like it.

  5. #5
    skyrat is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2018
    Posts
    19
    Anyhow : it works fine now ! I just put the Dutch words here in case any Dutch people might be searching for the same solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 05-16-2016, 01:46 PM
  2. Connecting TWO Databases with a link table
    By alfasprint in forum Database Design
    Replies: 5
    Last Post: 02-28-2016, 08:43 PM
  3. Replies: 8
    Last Post: 05-31-2013, 05:20 PM
  4. Creating a new MDB for separate databases?
    By SandyClark in forum Import/Export Data
    Replies: 1
    Last Post: 06-02-2011, 10:44 AM
  5. Split Databases
    By terricritch in forum Database Design
    Replies: 2
    Last Post: 09-14-2010, 05:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums