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
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
Setting column width in a table with a macro is not working 0
List all tables, including document structure 0
Creating a Search using a combo box and then creating a report. 4
Append Query/Relationships 1
Unable to display values in 2nd list box from 1st list box selection 2

Top