Limit for relationships from 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 index in PrimaryKey. But when I tried make
another relationship with integrity, fail and show message that has many
indexes in the table.
What is number limit for this relationships with a table?
 
K

Ken Snell \(MVP\)

From ACCESS Help (search on Specifications):

Number of indexes in a table 32
Number of fields in an index 10


Note that ACCESS creates some indices under the covers -- when you create
relationships, for example, or when you name a field ID -- in addition to
the ones that you create on your own. If you open the Index window in your
table's design view, you may find some duplicate indices there.
 

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 relationships for a field 2
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
List all tables, including document structure 0
Setting column width in a table with a macro is not working 0
Creating a Search using a combo box and then creating a report. 4
Relationships 9
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top