What is the limit of Access database everyone has experienced?

Observation of various small projects based on MS Access Db at work, records above 200,000 or 50MB seems to be more prone to corruption.

what is the prudent limit (not the theoretical one) everyone keeps their access database within vis-a-vis record numbers?