Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Toronto
    Posts
    5

    Unanswered: Maximum number of Records

    I have been put in charge of modelling a db that will hold 1.5 billion records. Can Access handle this, or should I go with my best instincts and get an oracle license?

    Thanks.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i believe that in theory A handles 2pointSomething x 10^9 records but you probably need something stronger when you get to the 10^5 or ^6 level.

    izy

  3. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Also are these 1.5 billion records in one table (doubt it )
    or is this the calculated total of all rows in the data base, including lookups, id tables, etc.?

    Still sounds like you may need SQL - oh I forgot you said oracle

  4. #4
    Join Date
    Jun 2003
    Posts
    45

    Question If the answer is convert to SQL/Oracle...

    I have similar problem but I'd like to extend it.
    If the answer is convert to SQL/Oracle THAN WHAT?

    Should I completely rewrite my database (all the tables, windows, queries and procedures) in some other product...
    OR
    Can I transfer database between MS Access and SQL Server and use my Access made Forms and Queries as front-end and converted in SQL Server database Tables as back-end of my new application (whitout rewriting all)?

  5. #5
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    yes you can upsize to sql from access and use the front end - some things will have to changeupsizing tool (2k and up) there are some great Q articles in the MS knowledge base at
    http://support.microsoft.com

Posting Permissions

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