M Mike Oct 23, 2003 #1 Does anyone know the maximum number of rows that MS Access will allow in a single table? Thanks
K Kevin3NF Oct 23, 2003 #2 No explicit number of rows defined....max file size for Access 97 is 1GB, Access 2000/2002 is 2GB -- Kevin Hill President 3NF Consulting www.3nf-inc.com/Newsgroups
No explicit number of rows defined....max file size for Access 97 is 1GB, Access 2000/2002 is 2GB -- Kevin Hill President 3NF Consulting www.3nf-inc.com/Newsgroups
T Tim Ferguson Oct 23, 2003 #3 Does anyone know the maximum number of rows that MS Access will allow in a single table? Click to expand... Unlimited up to the storage capacity of a mdb file, which is 2 GB. Hope that helps Tim F
Does anyone know the maximum number of rows that MS Access will allow in a single table? Click to expand... Unlimited up to the storage capacity of a mdb file, which is 2 GB. Hope that helps Tim F
