Limit relationships for a field

J

Jackson Romero

I have a bd in Access 2003 with 136 tables.
From a table (principal registries) it relation for many tables. This
relations is 1 to 1 or 1 to many.
This principal table has only an indice in PrimaryKey. But when I tried make
another relationship with integrity, fail and show message that has many
indices in the table.
What is number limit for this relationships with a table?
 
A

Allen Browne

A table can have only 32 contraints. Each
relationship-with-relational-integrity uses one of those, and so does each
index.

If you have 136 tables, including lots of 1-1 relationships, there's a
pretty good chance that it is not normalized. The best solution will be to
read up on normalization.

We don't know what data you are trying to manage, but there may be a way to
reorganize the structure.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit for relationships from a field 2
Append Query/Relationships 1
Temporarily disable relationships/constraints 1
Query joins not created in front end query grid 2
Make table query and Table Relationships (Notify Me) 2
Query on a set of optional M2M relationships 1
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
no table relationships defined 1

Top