Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    133

    Unanswered: maximum number of records

    hi all,

    This is general question only. How many number of records that Access can handle as a maximum records?
    Or it only depend on size limit (4GB)???
    thanks

  2. #2
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290
    sizelimit is one, and of course the memory size of the system on which it runs.

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by cuongvt
    hi all,

    This is general question only. How many number of records that Access can handle as a maximum records?
    Or it only depend on size limit (4GB)???
    thanks
    It depends on the version of Access.

    Access 97 had a total DB size limit of 1GB. The Max number of records would thus be substancially less than this.

    I believe that this memory limit was increased to 2GB in Access 2K

    If you use ADP files in Access (SQL Server/SQL Express) the max db size is 2 or 4 GB, depending on the version. But, the max number of records will be much less than this, as each record requires storing the data, plus overhead.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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