Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Capacity of Access 97 (Win ME/Access 97)

    Practically speaking, how much of a load on Access is a file of 60K to 80K records? Will there be much of a drag on performance? Is this still a practical size for Access to handle? Has anyone had any experience with large files and Access?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Capacity of Access 97 (Win ME/Access 97)

    If you use a table with that many records in a combo box on a form, yes, it will be slow.
    However, that many records in a table is easy for Access to handle, it can handle many hundreds of thousands of records. Just be sure to index them and your response time will be quick.
    I am sure otther people will add to this.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Capacity of Access 97 (Win ME/Access 97)

    In addition to Pat's comments, one variable is the size of individual records. If you have several memo fields with lots of text (or photos in OLE Object fields), you will quickly reach the maximum size for Access 97 databases. On the other hand, if each record only has two Long Integer fields, you could literally have millions of records, though you might want to index things which would increase the space required. As long as fields you do lookups by are indexed you should see good performance.
    Wendell

Posting Permissions

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