Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    London, Gtr London
    Thanked 0 Times in 0 Posts

    Database Design Issue (2003)

    I have a number of large database's which are linked to tables in an informix server.

    Each of these db's are performing different tasks and each db is of quite substantial size. For example one does my stock another looks after debtors while another looks after creditors etc.

    For my month end reporting I need to run routines in each respective db.

    What I was thinking is if I could link all the db's together, maybe using another db which would run all the routines I need to at month end, rather than running them separately.

    My questions are:

    Would this be a good idea? would it necessarily be more efficient?
    If so how could I do it?

    I would appreciate any ideas.

    Many thanks as always

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 40 Times in 39 Posts

    Re: Database Design Issue (2003)

    A single Access frontend can link to multiple backend databases, so that is not a problem.

    As to whether creating such a frontend database will help you, I think only you can make that decision. My understanding of the situation as you described it is that you are trying to save the time going from one database to another. Do you have any reports that in some way combines information found in 2 or more of these databases? If not, then it seems to me that you would spend more time setting up the new database then you'd save.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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