CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums
Results 1 to 7 of 7

Thread: access database limitation

  1. #1
    Join Date
    Nov 2004

    Arrow access database limitation


    Is there any limitation with the storage of records in Access 2000 Database?
    Pls help me...

  2. #2
    Join Date
    Jul 2004
    Chennai, India

    Smile Re: access database limitation

    Hi praveenjain, when compared with SQL Server and Oracle, Access 2000 has limitations in all aspects(Data storage,query optimization)


  3. #3
    Join Date
    Apr 2002

    Re: access database limitation

    check this thread :

    also read this from access help :
    Access database
    Attribute Maximum
    Microsoft Access database (.mdb) file size 2 gigabytes minus the space needed for system objects.
    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


    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
    note that there is a size limit not a row number limit
    atually i faced severe problems with large access databases (60 MB+)
    Hesham A. Amin
    My blog , Articles

    <a rel=" border="0" /> @HeshamAmin

  4. #4
    Join Date
    Sep 2001
    Québec, Canada

    Re: access database limitation

    Yes, Access tend to be very slow when having large database like 100MB and more. While the limit is 2 Gigs, it's just theoric, same with the numbers of users, Access start slowing where there is like 20 users at the same time, think about 255...

    CodeGuru VB FAQ Visual Basic Frequently Asked Questions
    VB Code color Tool to color your VB code on CodeGuru
    Before you post Importants informations to know before posting

  5. #5
    Join Date
    Nov 2004

    Re: access database limitation

    Thank you all for the reply..

    Praveen Jain

  6. #6
    Join Date
    May 2004
    Pell City, Alabama

    Re: access database limitation

    Biggest limitation in my experience is the inability to begin a transaction with an open cursor. Thats quite limiting.

  7. #7
    Join Date
    Nov 2004

    Re: access database limitation

Posting Permissions

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

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)