Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    11

    Unanswered: Use Address Database in another database

    I have many databases that have personal information tables. I would like to create a central personal information database from which the other databases can get the information from so that if an address is changed in one database I don't have to go to the other databases and change the address information there also.

    How can I make this happen?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Use linked tables in the client databases, that will refer to the c.p.i. database storing the actual data. File --> Get External Data --> Link Tables
    Have a nice day!

  3. #3
    Join Date
    Oct 2009
    Posts
    340
    I would consider consolidating them. And then using 1 table.

    To do so you first normalize them so they all have the same fields (with the same field properties)....they may already - but you want to check this first.

    Then decide which you wish to make into the new master table and generate a series of AppendQueries that will write i.e. Table 2 onto Table 1, Table 3 onto Table 1, Table 4 onto Table 1.

    .....making Table 1 the master. Then delete the others, and link every Front end or db to Table 1

    hope it helps.
    www CahabaData com

  4. #4
    Join Date
    Sep 2004
    Posts
    11

    Linked Tables to another Database

    Thank you for your replies. Linking worked just like I need it to.

    Have a great day!

Posting Permissions

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