maximum number of records in a table

[carolyn]

I am wondering if it is possible to have an Access Table
with 6 million records in one table. If not, what
database program could handle it?

Thanks
Carolyn

 

[Lynn Trapp]

As long as those 6 million records do not cause the file to be larger than
2GB (for A2K and later -- 1GB for A97 and earlier), the answer is yes. If
that happens then you would need to use a client/server database system such
as SQL Server or Oracle.

 

[John Vinson]

I am wondering if it is possible to have an Access Table
with 6 million records in one table. If not, what
database program could handle it?

That's big for Access, but I know of 20,000,000 row tables. Your real
limitation is the 2 GByte per .mdb file - depending on how large these
six million records are you could be pushing that limit pretty hard
(that's an average of 333 bytes per record, not counting overhead or
your other tables).

SQL/Server, MySQL, Oracle, Visual FoxPro, DB/2... lots of DBMS's can
handle this size with equinamity (and with a lot more investment of
programming and implementation labor).

 

[Lynn Trapp]

(and with a lot more investment of

programming and implementation labor).

And a much, much larger investment in $$$ <g>


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm