I have never seen such an exact limit. Many factors impacts performance like indexes (you need some but not too much), the presence of a blob field (like an image), memo fields, the number of columns, the way you write your queries, the kind of interaction with the database (read only or read-write), the state of the database (compacted on a regular basis), ...
>I heard that if using MS Access it reaches more then 24,000 records that it becomes less efficient or that databse will run slower. Is this true?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com