The maximum number of records is defined by the size and number of fields.
I have successfully linked several databases in the past, but never to the size you are describing.
I only hit the 2GB limit once, and that was because I was inserting pictures, which Access converted to bitmaps.
A database that is very active, lots of records adding and deleting, will also grow quickly. Regular compacting is often necessary.