What is the maximum number of records that a database table can have?

There may be a problem handling tables of around 5,000,000 records or more?