FYI, you can easily get info about all limits by entering Specs in Help and then clicking on Microsoft Access Specifications and follow from there.
Practically, the only limit for tables/records is 255 fields per table/record and 2,000 characters per record (excluding Memo and OLE Object fields)