Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Too Many Indexes

Status
Not open for further replies.
InyoTom

InyoTom

Technical User
Feb 4, 2000
33
0
0
US
Access won't let me define more relationships. It claims I would exceed the limit of 32 indexes. This is an accounting app, and I do have a lot of relations defined for the AccountNumber field. The specific message, when I try to create another relation to AccountNumber is: "The operation failed. There are too many indexes on the table "tblChartOfAccounts". Delete some of the indexes on the table and try again." (This is kind of like saying I am too old to get in here - go get younger and try again.)

Anybody had any experience with this odd limit?

Tom Budlong
TomBudlong@Bigfoot.com

 
Status
Not open for further replies.

Similar threads

N2Life
  • Locked
  • Question
Graph too small in Office 365 Access
Replies
0
Views
42
N2Life
N2Life
Moss100
  • Locked
  • Question
Turn one to many relationship into single records 2
2
Replies
34
Views
201
Moss100
Moss100
Bill6868
  • Locked
  • Question
Too Many Objects in Database?
Replies
2
Views
34
lameid
lameid
BallunarCrew
  • Locked
  • Question
Attachments table it too large - need alternative 2
Replies
2
Views
27
Blorf
Blorf
JOEYB99
  • Locked
  • Question
Slow Database, Need Indexes? 1
Replies
9
Views
28
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top