Results 1 to 3 of 3

Access Capacity Limits

This is a discussion on Access Capacity Limits within the Microsoft Access forums, part of the Question Forums category; What are the capacity limits for Access? How many gigabites? In addition, is there a max number of rows or ...

  1. #1
    New Member
    Join Date
    Sep 2006
    Posts
    2

    Default Access Capacity Limits

    What are the capacity limits for Access? How many gigabites? In addition, is there a max number of rows or columns?

  2. #2
    Board Regular Cbrine's Avatar
    Join Date
    Dec 2003
    Location
    Brampton
    Posts
    3,191

    Default

    Do a help serach on Access Specifications. Here's the database limitations, but others are listed as well.

    Attribute Maximum
    Microsoft Access database (.mdb) (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) file size 2 gigabytes minus the space needed for system objects (system object: Database objects that are defined by the system, such as the table MSysIndexes, or by the user. You can create a system object by naming the object with USys as the first four characters in the object name.).
    Number of objects in a database 32,768
    Modules (including forms and reports with the HasModule property set to True) 1,000
    Number of characters in an object name 64
    Number of characters in a password 14
    Number of characters in a user name or group name 20
    Number of concurrent users 255

    Table Limits
    Number of characters in a table name 64
    Number of characters in a field name 64
    Number of fields in a table 255
    Xcelerated Solutions
    Office Automation Solutions for the Toronto Area

  3. #3
    New Member
    Join Date
    Sep 2006
    Posts
    2

    Default

    Thank you!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com