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

Thread: access database limitation

Hybrid View

  1. #1
    Join Date
    Nov 2004
    Posts
    20

    Arrow access database limitation

    Hi

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

  2. #2
    Join Date
    Jul 2004
    Location
    Chennai, India
    Posts
    1,064

    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)

    Madhivanan

  3. #3
    Join Date
    Apr 2002
    Location
    Egypt
    Posts
    2,210

    Re: access database limitation

    Hi.
    check this thread :
    http://www.codeguru.com/forum/showthread.php?t=292197

    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

    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
    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=https://twitter.com/HeshamAmin" border="0" /> @HeshamAmin

  4. #4
    Join Date
    Sep 2001
    Location
    Québec, Canada
    Posts
    1,923

    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...

    JeffB
    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
    Posts
    20

    Re: access database limitation

    Thank you all for the reply..


    Praveen Jain

  6. #6
    Join Date
    May 2004
    Location
    Pell City, Alabama
    Posts
    126

    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
    Posts
    1

    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)