Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    19

    Unanswered: When is too much for Access far too much?

    A change in database needs has me building a db of 93,000 records. Suddenly I think I have found the limit of Access. Where can I find what the limit is, and can I increase it? If I knew I could divide the information over two or more tables? Grateful for some guidance. Cheers Kupe

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    There is no limit in records in Acces the only limit is a size limit of 1.5Gb If you are reaching this size you may want to move older records to another 'archive' database
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    May 2003
    Posts
    19
    Many thanks, Machado.

Posting Permissions

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