Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Looking Up Other Databases (Access 2000)

    Here is the scenario. I have 10 separate databases ( one.mdb, two.mdb, three.mdb, etc. ) All 10 currently hold identical costing information. If there is a cost change, I need to go to each database and make the same changes. I want to be able to put the costs into a database called cost.mdb and be able to refer to them by the other 10 databases. When there is a costing change, I need only change the one database.
    So, how exactly do I
    (a) Refer to the costing data from the 10 databases, and
    ([img]/forums/images/smilies/cool.gif[/img] When there is a change, roll that change across all 10 databases.

    Thanks in advance for any help on this.
    Cheers,
    Andy

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Looking Up Other Databases (Access 2000)

    Of course, the first question any of us have is: why do you have 10 identical databases? Are all of them always available to be looked at by this cost.mdb? The answers to your question will vary depending on the situation.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Looking Up Other Databases (Access 2000)

    Link to a table in the cost.mdb file from the other ten db's.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking Up Other Databases (Access 2000)

    Mark:
    I appreciate your taking the time to look at my question. Two things I have to point out. Firstly, you are correct in your assessment based on the minimal information I gave you. Simply put, and without going to great lengths, each database is similar in structure, but because of the manner in which the client wants data kept separately, I had to separate them. It was political. Dumb, but political. Secondly, this has turned to be one of those 'you can't see the forest for the trees' sort of things. I've been linking front ends to back ends, etc. since getgo. I have absolutely no idea why the linking procedure didn't come to mind. Senility probably. Anyway, thanks again for your time, it's always appreciated.

    Andy
    Cheers,
    Andy

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking Up Other Databases (Access 2000)

    Paul
    My thanks to you for your answer. Read my reply to Mark and you'll get some idea of what happened. Duh!

    Andy
    Cheers,
    Andy

Posting Permissions

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