Results 1 to 3 of 3
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Combining Multiple Back End Databases (Access 2003/SP2)

    Here is the situation:
    A client has a database that they've designed themselves. It records hours worked and costs. They like it. They copy the database (front and backend) 2 more times for 2 other locations (3 dbs in total now). They feel this makes more sense than expanding the original db to include different locations/rate structures.
    However, now they want to run reports that amalgamate information from all 3 dbs (so that they don't have to run the same report in each db).

    So far, I'm considering 2 options:
    1) Linking the 3 back ends to one front end db. (But won't this be a pain because of the duplicate table names).
    2) Convincing them that it is better to bite the bullet and redesign the back end to encompass all locations and rate structures. (They think I'm overly fussy).

    Any suggestions that I haven't thought of? Arguments for one option vs another?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Combining Multiple Back End Databases (Access 2003/SP2)

    I would go for option 2, that means that all the data is in one backend, thereby making any queries etc straight forward, else you are up for UNION queries everywhere.

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

    Re: Combining Multiple Back End Databases (Access 2003/SP2)

    I agree with Pat. Converting to a single backend will be a lot of work, but it will result in a much more flexible setup.

Posting Permissions

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