MS Access linked tables

Is there a maximum number of tables that can be linked in an Access database?  If so, how many.
Who is Participating?
Jeffrey CoachmanMIS LiasonCommented:
Obviously there may be some "performance" issue if you are linking to many tables in many databases, many locations...
But like MX, I don't know of any hard "Limit"

As a wild guess, I would think that a "Low" limit might be 255...?
Based on my experience, ...I have worked with Databases that had over 100 linked tables
Perhaps MX has more experience with DB's with more linked tables than this.

But again, this is just a wild guess.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Don't recall ever seeing a limit.
How many do you have in mind ?

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Only thing so of related is this:

"Number of open tables 2048; the actual number may be less because of tables opened internally by Microsoft Access "

uadAuthor Commented:
Thank you - I will keep this in mind.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.