Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Oklahoma City, Oklahoma, USA
    Thanked 0 Times in 0 Posts

    Linked table question (AXP)

    I have a large database of inmates in a county jail. When the database was written, 3 years ago, I didn't know I would need to add things and didn't plan well.

    I now need to add a table in the back end and link it to 12 computers running the front end. The table was created in the front end, it is a table listing medications that are on our ** Possible SPAM post - please alert a Moderator (2)** formulary. We changed pharmacies and now whenever I make a change to the formulary, which has become a monthly issue, I need to copy the table to all the front ends.

    I want to put the table on the back end and link it once to all the front ends. I don't know how to do this though because when I open the linked table manager it only lists those table that were originally part of the database and the new table is not there.

    I am completely lost. <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

    Please help <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Linked table question (AXP)

    The Linked Table Manager is for changing existing links, not for creating new ones.

    To create a new link, select File/Get External Data/Link Tables...

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Melbourne, Australia
    Thanked 27 Times in 27 Posts

    Re: Linked table question (AXP)

    What Hans has said is right on the money if the table is in the back end.

    Have you moved your table to the back end? Do you know how to do this?

    If not, go into the back end database and:
    1. Click on the Table tab
    2. Click on File
    3. Click on Get External Data
    4. Click in Import
    Then it is just a matter of telling the resultant dialog box where the front end database is.

    Post back if you have any problems.


Posting Permissions

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