Access versus SQL Facts Available

Results 1 to 2 of 2

Thread: Access versus SQL Facts Available

  1. #1
    JudyG Guest

    Default Access versus SQL Facts Available

    Does anyone know where to find documented facts on when to make the upgrade from Access to SQL for web/intranet purposes. I&#039ve HEARD Access can handle about 15-20 simultaneous transactions and will just about stop after that, but I cannot find this information documented anywhere. Any suggestions appreciated. TIA, JudyG.

  2. #2
    SPG Guest

    Default RE: Access versus SQL Facts Available

    Funny, I came up with 5 before performance dropped like a rock.<BR><BR>Simple test -- Get the "Web Application Stress" tester from Microsoft (run a search on that phrase) and just keep increasing the concurrent connections until you feel your site is going too slow -- and that&#039s the number you pass up the financial chain to justify a database upgrade.

Posting Permissions

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