In Access 97, you can go to HELP>>CONTENTS AND INDEX>>INDEX and search for "specifications". It will tell you everything you ever need to know about Access's technical specifications. The same info is likely available in Access 2000/2002, but I don't have them readily available on this computer--give it a try to see what you come up with.
To specifically answer your question: 4500 rows of data is no problem at all for Access.
The user who earlier posted that an Access query can return only 150 rows is mistaken: I regularly deal with hundreds of thousands of rows of data in both queries and tables. Each week, I download 450,000 rows from our system and process over 250,000 active ones so that they can be queried, etc. It's a piece of cake for Access.
Access 97 database containers (.mdb files) max out at a gig. However, by attaching tables stored in other containers, the amount of data you can store is limited only by available harddrive space. I believe that more recent versions of Access have a 2 gig limit on .mdb files, but by attaching to tables within other containers as I just mentioned, you can overcome the limit here, too.
In short, I don't know of a MORE "robust" PC-based database than Access, though I'm sure there are some that are equally as robust.
I hope this helps!!!
KL