Max no. of joins from a table

richardn

Registered User.
Local time
Today, 08:57
Joined
Nov 6, 2001
Messages
49
What's the maximum number of joins (primary keys) from a table in MS Access XP ?
Is this possible to change this limit?
Thanks,
Richard
 
I came across a poorly designed app that had about 60 1-1 relationships. I tried to enforce RI and Jet choked at some point less than that. I don't remember exactly when it refused to create any more relationships. I had to convert the db to SQL server since I felt that RI was necessary. So, that tells you that this is not a customizable limit.

I have never exceeded the maximum in any properly designed db. Even very large ones.
 

Users who are viewing this thread

Back
Top Bottom