Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked Access tables (Office 97 SR2)

    Hi:
    I need a little advise about linked tables. I have a database that draws its data (via linking) from monthly databases that our system generates. In fact, I recently completed linking for all of 2002 and 2003 (I created blank databases to link to for all future months; i.e., each month the real database will be pasted over the blank one, which does not disturb the link). So, I created 24 blank databases and 24 links. I also did this for 5 other projects (a total of 144 links). Now, the client has decided that he wants to change the name of the parent folder (same drive) where all these files are stored. That means, I guess, that I will have to change the path in the links. My question is: "how do I do this?" I could not even find a way, in ACCESS, to inspect the link to see how the path reads. I hope that I am not going to have to redo all these 144 links manually.
    Help! <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Access tables (Office 97 SR2)

    Stephen: The Linked Table Manager will give you the paths that currently exist. In Access 2000, it's found under Tools, Database Utilities; in Access 97, it may be in the same place or it may be an add in. Regardless, this is where you can inspect the links. HTH.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Access tables (Office 97 SR2)

    Are you familiar with the linked table manager? Look under tools...add-ins. When the dialogue opens, select tha tables whose links you want to change. Click on the "Always prompt for new location" checkbox and click on OK. The office common dialog will open and you can browse to the new/renamed folder.

    This seems like an awkward setup but I'm sure I'm missing something. Is there a reason you cannot keep all of the tables you link to in one file?

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Access tables (Office 97 SR2)

    Hi Paul:
    Thanks to you and Bill for your quick response. Paul, this is a long story and the only short answer that I can give you is the ols adage "if it ain't broke, then don't fix it". Actually, we can thank Mr Demming for that one.
    Anyway, at present, there is no way I can stop the generation of the direction of these monthly files into separate folders. In fact, each little database is generated has the same name each month, which made it even more difficult to harvest their data. I finally got them to put the year and month in the filename along with the a 3-letter project designator.
    What can I say, other than that this is a government funded project and the original software was developed by a subcontractor.
    I keep trying, though.
    Thanks for your interest. You will no doubt be seeing more questions from me in the future.
    Stephen <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Linked Access tables (Office 97 SR2)

    I used to *be* a government contractor. You wouldn't believe some of the bad designs I saw because the contracts went to people who didn't know anything about database design so they let the user tell them how to design it. <img src=/S/sick.gif border=0 alt=sick width=15 height=15>
    Charlotte

Posting Permissions

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