Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Access Database - How much can it take?

    Hi

    Can anyone advise of the performance capabilites of Access Database, say, compared to SQL, for example, how much traffic and concurrent users it can take and how much information it can hold before SQL (for example) is required.

    Help apprecieted.

    Mattys

  2. #2
    Join Date
    Feb 2004
    Location
    Pittsburgh, PA
    Posts
    41
    Quote Originally Posted by mattys
    Hi

    Can anyone advise of the performance capabilites of Access Database, say, compared to SQL, for example, how much traffic and concurrent users it can take and how much information it can hold before SQL (for example) is required.

    Help apprecieted.

    Mattys
    Hi Mattys,

    Everything I have read says that Access can only handle 5 concurrent users. The database size limit is also 2 GB. The locking for multiple users is also much better on SQL Server.

    So if you have the budget, and are worried about these 2 factors I would buy SQL Server.

    Hope this helps,

    John

Posting Permissions

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