Too many indexes

J

jACk

I was hoping that the upgrade to Access 2002 from Acess 98
would eliminate the indexing limit when enforcing
Referencial Integrity on a join but that doesn't seem to
be the case. Has anyone else run into this problem and if
so, any suggestions on getting around it.
 
J

Joe Fallon

The limit has always been 32.
I have never hit 10 in over a decade of using Access.
You may want to review the design of your DB.
 
T

Tony Toews

Joe Fallon said:
The limit has always been 32.
I have never hit 10 in over a decade of using Access.
You may want to review the design of your DB.
Click to expand...

I have. But then the MDB had 150 tables.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

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

Too Many Indexes Bug 5
Too many indexes 10
too many indexes 1
Too Many Indexes Error 3
Too many indexes warning on table import 5
how to get external data 0
Too Many Indexes 2
Need VBA Macro to Loop through pages and print counter in footer of each page 9

Top