Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Microsoft Access Limits (file size, table records, users)

Discussion in 'Information Technology' started by Mike, Nov 4, 2005.

  1. Mike

    Mike
    Expand Collapse
    Guest

    What is the largest MDB file size possible?

    What is the largest amount of records you can have in one table?

    What is max amount of users you can have accessing any one MDB file?

    Thank you in advance for any information! (smile)

    Mike
     
  2. Loading...

    Similar Threads Forum Date
    Microsoft Warning Over Browser Security Flaw Information Technology Feb 1, 2011
    World Microsoft Apologizes for Changing Race in Photo Breaking News Aug 26, 2009
    DOWNLOAD BANI FILES - Microsoft Word Format Discourses in English Feb 11, 2008
    Microsoft Throws Prime-Time Party for Next Xbox (washingtonpost.com) Interfaith Dialogues May 14, 2005
    Microsoft Unveils New Windows Mobile (AP) Interfaith Dialogues May 11, 2005

  3. Kernow Girl

    Kernow Girl
    Expand Collapse
    Guest

    From the Help Screens - hope this helps!

    Access specifications
    Microsoft Access database specifications
    Access database

    Attribute Maximum
    Microsoft Access database (.mdb) 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

    Attribute Maximum
    Number of characters in a table name 64
    Number of characters in a field name 64
    Number of fields in a table 255
    Number of open tables 2048; the actual number may be less because of tables
    opened internally by Microsoft Access
    Table size 2 gigabyte minus the space needed for the system objects
    Number of characters in a Text field 255
    Number of characters in a Memo field 65,535 when entering data through the
    user interface;
    1 gigabyte of character storage when entering data programmatically
    Size of an OLE Object field 1 gigabyte
    Number of indexes in a table 32
    Number of fields in an index 10
    Number of characters in a validation message 255
    Number of characters in a validation rule 2,048
    Number of characters in a table or field description 255
    Number of characters in a record (excluding Memo and OLE Object fields) 2,000
    Number of characters in a field property setting 255

    Query

    Attribute Maximum
    Number of enforced relationships 32 per table minus the number of indexes
    that are on the table for fields or combinations of fields that are not
    involved in relationships
    Number of tables in a query 32
    Number of fields in a recordset 255
    Recordset size 1 gigabyte
    Sort limit 255 characters in one or more fields
    Number of levels of nested queries 50
    Number of characters in a cell in the query design grid 1,024
    Number of characters for a parameter in a parameter query 255
    Number of ANDs in a WHERE or HAVING clause 99
    Number of characters in an SQL statement approximately 64,000

    Form and report

    Attribute Maximum
    Number of characters in a label 2,048
    Number of characters in a text box 65,535
    Form or report width 22 in. (55.87 cm)
    Section height 22 in. (55.87 cm)
    Height of all sections plus section headers (in Design view (Design view: A
    window that shows the design of these database objects: tables, queries,
    forms, reports, macros, and data access pages. In Design view, you can create
    new database objects and modify the design of existing ones.)) 200 in. (508
    cm)
    Number of levels of nested forms or reports 7
    Number of fields or expressions you can sort or group on in a report 10
    Number of headers and footers in a report 1 report header/footer; 1 page
    header/footer; 10 group headers/footers
    Number of printed pages in a report 65,536
    Number of controls and sections you can add over the lifetime of the form or
    report 754
    Number of characters in an SQL statement that serves as the Recordsource or
    Rowsource property of a form, report, or control (both .mdb and .adp) 32,750

    Macro

    Attribute Maximum
    Number of actions in a macro (macro: An action or set of actions you can use
    to automate tasks.) 999
    Number of characters in a condition (condition: Part of the criteria that a
    field must meet for searching or filtering. Some conditions must be used with
    a value; for example, the field Author with the condition equals with the
    value Jane. Author equals, by itself, would be incomplete.) 255
    Number of characters in a comment 255
    Number of characters in an action argument (action argument: Additional
    information required by some macro actions — for example, the object affected
    by the action or special conditions under which the action is carried out.)
    255

    Microsoft Access project specifications
    Access project

    Attribute Maximum
    Number of objects in a Microsoft Access project (.adp) (Microsoft Access
    project: An Access file that connects to a Microsoft SQL Server database and
    is used to create client/server applications. A project file doesn't contain
    any data or data-definition-based objects such as tables and views.) 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 columns in a table 250 (Microsoft SQL Server 6.5)
    1024 (Microsoft SQL Server 7.0 and 2000)


    Microsoft SQL Server database

    Microsoft SQL Server maximum capacity specifications are described in the
    SQL Server documentation. For more information about SQL Server Books Online,
    see the Microsoft Developer's Network Web site.

    Note The hyperlink in this topic goes to the Web. You can switch back to
    Help at any time.

    Form and report

    Attribute Maximum
    Number of characters in a label 2,048
    Number of characters in a text box 65,535
    Form or report width 22 in. (55.87 cm)
    Section height 22 in. (55.87 cm)
    Height of all sections plus section headers (in Design view (Design view: A
    window that shows the design of these database objects: tables, queries,
    forms, reports, macros, and data access pages. In Design view, you can create
    new database objects and modify the design of existing ones.)) 200 in. (508
    cm)
    Number of levels of nested forms or reports 7
    Number of fields or expressions you can sort or group on in a report 10
    Number of headers and footers in a report 1 report header/footer; 1 page
    header/footer; 10 group headers/footers
    Number of printed pages in a report 65,536
    Number of controls and sections you can add over the lifetime of the form or
    report 754
    Number of characters in an SQL statement that serves as the Recordsource or
    Rowsource property of a form, report, or control (both .mdb and .adp) 32,750

    Macro

    Attribute Maximum
    Number of actions in a macro (macro: An action or set of actions you can use
    to automate tasks.) 999
    Number of characters in a condition (condition: Part of the criteria that a
    field must meet for searching or filtering. Some conditions must be used with
    a value; for example, the field Author with the condition equals with the
    value Jane. Author equals, by itself, would be incomplete.) 255
    Number of characters in a comment 255
    Number of characters in an action argument (action argument: Additional
    information required by some macro actions — for example, the object affected
    by the action or special conditions under which the action is carried out.)
    255


    "Mike" wrote:

    > What is the largest MDB file size possible?
    >
    > What is the largest amount of records you can have in one table?
    >
    > What is max amount of users you can have accessing any one MDB file?
    >
    > Thank you in advance for any information! (smile)
    >
    > Mike
    >
    >
    >
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Kernow Girl's shown you what the Help file says, but let's interpret what it
    says with respect to your specific questions.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Mike" <nospam@nospam.com> wrote in message
    news:11mkbj4qji3c29@corp.supernews.com...
    > What is the largest MDB file size possible?


    2 Gb for Access 2000 and newer, 1 Gb for previous versions.

    > What is the largest amount of records you can have in one table?


    There is no limit per se. A table can have as many rows as will fit in the
    MDB file.

    > What is max amount of users you can have accessing any one MDB file?


    The absolute limit is 255, but I doubt very much that you'll be able to get
    anywhere near that in production. It's not really possible to give an
    absolute number, though: a lot depends on what the users are doing
    (read-only vs. updating), how well designed the database is, and how good
    the network is.

    One definite, though: you should split the application into a front-end
    (containing the queries, forms, reports, macros and modules) and a back-end
    (containing the tables). Only the back-end should be on the server: each
    user should have his/her own copy of the front-end, preferably on their hard
    drive.
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest


    >number of users: 1
    >
    >average number of days without crashing: 7


    Rubbish. I have clients who've been using Access for years without crashing.

    >USE MSDE or SQL SERVER you will have much much better results.


    But for a significantly greater administration requirement.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  6. Tony Toews

    Tony Toews
    Expand Collapse
    Guest


    >MDB is a waste of time; a PITA
    >and a complete and utter dead-end


    Wrong

    >if you want SCALABLE, RELIABLE, MULTI-USER APPS (that work across a
    >network, snicker-snicker) then you should be using MSDE or SQL Server.


    MDBs work fine on a network.

    >MSDE / SQL SERVER DOESNT TAKE ANY -- IT DOESNT TAKE _ANY_ MORE
    >ADMINISTRATION THAN MDB.


    Sure they do. Plus if you're in a shop run by an IT department you won't have install
    rights so you can't install MSDE anywhere. And the IT dept likely won't let you
    access the SQL Server systems.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page