Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Which backend are tables linked to? (2000, 2002)

    We have a database that is split into a front end and back end. The back end is housed on one computer and that user also has a front end on the same computer. Other people who use the database have the front end on their local machine and it connects to the back end on her machine through the network. We have been using this system and, in fact, the same files, for several years.

    Suddenly, updates that I make through my front end are NOT showing up on the backend, and updates that the primary user is making through her front end do not show up when I open my front end!

    In order to trouble shoot, I first wanted to see where the linked tables in my front end and her front end were pointing. So my first question (and maybe this will lead us to the ultimate solution) is how do I tell where they are pointing? I thought the properties of the linked table would show it, but it does not seem to.

    Please advise.

    Thank you,
    -cynthia

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Which backend are tables linked to? (2000, 2002)

    You can use Tools | Database Utilities | Linked Table Manager to see which database each linked table is used to.
    Or open a linked table in design view. Access will protest, click Yes anyway.
    Activate the Properties window. The Description property will contain DATABASE= followed by the path and filename of the backend.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Which backend are tables linked to? (2000, 2002)

    Organizer (who asked the question originally) wanted to verify which database the tables were linked to. If you already know, that's not necessary.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Which backend are tables linked to? (2000, 2002)

    I am sorry I had made post in a wrong thread!

  5. #5
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Which backend are tables linked to? (2000, 200

    Thank you Hans! It's been too long since I played with the linked tables, I guess.
    I'm away from that computer now but will try that when I get back later today and expect that it will lead us to the answer to the problem.

    -cynthia

Posting Permissions

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