Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2003
    Location
    London, Gtr London, England
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiuse DB's (2000 (9.0.6926 SP-3))

    Hi there!

    I am looking for some guidance as to designing multiuser DB

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

    Re: Multiuse DB's (2000 (9.0.6926 SP-3))

    With a slow network, increasing the size of the database (a logical consequence of merging the four databases into one) might cause problems. If you decide to go through with it, I would certainly opt for a split design, with a shared backend and a local copy of the frontend for each individual user.

    - It allows you to store temporary tables in the frontend, diminishing the probability of conflicts and of corruption of the backend.
    - It allows you to provide different functionality in the frontends if needed.
    - It allows you to test new or modified functionality in your own copy of the frontend without kicking out all other users.

    Apart from that, make sure that you have a good backup policy. Make a full backup of the database every night as a minimum, and if possible make snapshots every few hours.

  4. #3
    3 Star Lounger
    Join Date
    Nov 2003
    Location
    London, Gtr London, England
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiuse DB's (2000 (9.0.6926 SP-3))

    Hans!

    Many thanks for that, it's confirmation of what I had in mind. I'm actually trying to resist those who are above me here, but basically who don't have a clue, who are saying just do it! This will enable me to resist effectively their demands. Further, this will also help me in improving the network infrastructutre here. Just to let you know, we timed the output from one DB i.e. from running the queries which extract, process, build and export the required data to the format required for Lloyd's over our network and on average it took 23 minutes (This was just one Syndicate out of 12 for all four Clients.). Locally (C: Drive), it took 30 seconds!!!!

    Cheers again,

    Niven <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    P.s. Good to see you all back again.

  5. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: Multiuse DB's (2000 (9.0.6926 SP-3))

    Wow! Those times should convince the powers that be!

Posting Permissions

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