>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?

I see that other folks have chimed in already but I wanted to add my own experience. First of all, I am not a fan of Access.... but I have seen apps with tables with tens of thousands of records (certainly close to 100,000) which still had great performance. I think it depends on how the forms and reports are coded, and the database design.

Having said that, there are loads of things I don't like about Access -- I have seen multi-user issues with Access 2000 with as few as 8 users; I really don't like the idea of the single-mdb file; and generally it sees to me that Access is great as a wizard-style tool, but the minute you need to do something more complicated, you're working against it, not with it.