It depends on the nature of data, application, data access and environment. So, a few factors.
In any case the database should be split into frontend and backend. I hope you are already talking about the backend file only.
It is not a problem to link two or more Access backend files into a frontend. Either divided contentwise or organizationally, e.g. with current and archive data, which is also good for performance.
What of it makes sense or if you should better go to a SQL Server or the like, can only be said on the basis of more details.