Results 1 to 7 of 7

Thread: Max Size of Access DB

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Oct 1999
    Posts
    101

    Post

    Does anyone know the Maximum size of an Access DB? Is there a limit to the amount of records that an Access table can hold?

    Thanks,

    Chris

  2. #2

    Thread Starter
    Lively Member
    Join Date
    Oct 1999
    Posts
    101

    Post

    No need for help.

    I found out that it is about 1 Gig.

    Chris

  3. #3
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923

    Post

    Just incase you needed confirmation, it is about a Gig for Access 95, possibly as well Access 97 but for 2000 I don't know. Access 1 was only 128Mb!!

    regards

    ------------------
    - Chris
    [email protected]
    If it ain't broke - don't fix it

  4. #4
    Addicted Member
    Join Date
    Oct 1999
    Location
    Brossard, Québec, Canada
    Posts
    241

    Post

    In terms of the amount of records.... I have Access 2000 and added 2 millions (not kidding) to a table and it still worked fast and just fine... npw if you have more than 2 million records... I Hope it pays good money

  5. #5
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744
    Access95/97 - 1GB
    Access2000/2002 - 2GB

  6. #6
    I'm about to be a PowerPoster! kleinma's Avatar
    Join Date
    Nov 2001
    Location
    NJ - USA (Near NYC)
    Posts
    23,373
    I hate access now... i used to like it until it started crashing left and right when people over a network were accessing it... now it is SQL Server all the way baby!!

  7. #7
    I'm about to be a PowerPoster! kleinma's Avatar
    Join Date
    Nov 2001
    Location
    NJ - USA (Near NYC)
    Posts
    23,373
    -

Posting Permissions

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



Click Here to Expand Forum to Full Width