Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data base design (Access 2003 Windows XP)

    I am designing a data base which, for me, is somewhat complicated. It looks like the problem could be divided up into three loosely related, smaller problems. These smaller problems will have to be related eventually.

    Is it good practice, or even feasible, to develop three separate data bases, and then link tables/queries in order to develop final summary information?

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

    Re: Data base design (Access 2003 Windows XP)

    It's hard to say without knowing any specifics, but I'd tend to store the tables in a single backend, so that they can easily be combined in queries. You could create different frontends for the subproblems.

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data base design (Access 2003 Windows XP)

    I had not thought of that. I will give it a try with all tables in one back-end, and the separate problems in different front-ends. Thanks.

Posting Permissions

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