Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: collecting data from different mdbs

    Dear netters,

    I'm trying to set up a db architecture for a community school environment with the following restrictions:
    - each school uses a simple application, storing data in an an .mdb file
    - school data must asynchronously update a central server (SQL server) that stores data from all the school files and publishes them on the www
    - no permanent interner connection is guaranteed (schools work offline and update the server periodically)

    I'm checking MS solutions for the above requirements. Is "replication" the right place to start? Should I look into some other capability of Ms products (wharehousing?)?

    I would appreciate some guidelines on how to organise my search for solutions.

    Thanx in advance,

    Vas.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Mail the req's and I'd be glad to consult....cheap rates!

    No replication is not the place to start..

    A entity relationship model is...

    Actually a process model diagram is....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Posts
    522
    come on, we're talking about school system here! they can't afford to pay teachers the rate that they deserve! ...and what are your rates?

    but you're right, - process model combined with the erd will give us an idea here on how to tackle this.

Posting Permissions

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