Tables relationship

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

What is the limitation on amount of tables that can be linked with index
from a table. After linking to 27 tables with the referential integrity,
cascade update and delete, it will not allow further link with another table
with referential integrity.
 
What is the limitation on amount of tables that can be linked with index
from a table. After linking to 27 tables with the referential integrity,
cascade update and delete, it will not allow further link with another table
with referential integrity.
Click to expand...

The limit is on the number of Indexes in a table - 32. Do you have one
"sea urchin" table with relationships to 27 other tables? If so,
you're surely pushing this limit. If the relational design is correct
and you need to have this structure, unfortunately, there isn't any
way to change the limit! You may need to have some tables' relational
integrity enforced in code rather than through table relationships.
 
You are limited to 32 indexes on one table. Each time you link a field in a
table, Access creates another index. But if the links are all ( mostly ) on
the primary key, you should not run into this problem except for very
unusual designs.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top