• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

MS Access linked tables

Is there a maximum number of tables that can be linked in an Access database?  If so, how many.
0
uad
Asked:
uad
  • 2
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Don't recall ever seeing a limit.
How many do you have in mind ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 "

mx
0
 
Jeffrey CoachmanCommented:
Obviously there may be some "performance" issue if you are linking to many tables in many databases, ...in 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.
0
 
uadAuthor Commented:
Thank you - I will keep this in mind.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now