A Allen Browne Apr 4, 2005 #2 There is no limit to the number of records in a table. The practical limit is that the database size cannot exceed 2GB.
There is no limit to the number of records in a table. The practical limit is that the database size cannot exceed 2GB.
J John Vinson Apr 4, 2005 #3 hi, How many records can I have in ms access? what is the limit. thanks Click to expand... No specific limit, as Allen says; in practice, about the largest production Access database table that I know of has some 20,000,000 records. Tens to hundreds of thousands of records are quite routine and managable. John W. Vinson[MVP]
hi, How many records can I have in ms access? what is the limit. thanks Click to expand... No specific limit, as Allen says; in practice, about the largest production Access database table that I know of has some 20,000,000 records. Tens to hundreds of thousands of records are quite routine and managable. John W. Vinson[MVP]
