By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Too many relationships?

Expert 100+
P: 1,892
I am building some relationships however, the latest one always tells me there are too many indexes. I counted 13 is there a way to make as many as I want?
Thanks
Oct 26 '06 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,494
No - there are inbuilt limits in Access.
Oct 26 '06 #2

Expert 100+
P: 1,892
How can I reduce the number of indexes then?
Oct 26 '06 #3

NeoPa
Expert Mod 15k+
P: 31,494
No-one can do this for you.
You need to analyse your setup (data; table layouts; etc).
It may well be that it is not possible in your case.

Obviously consider leaving out indices which are the least important, but other than that you need to analyse what you've got.
Oct 26 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
I am building some relationships however, the latest one always tells me there are too many indexes. I counted 13 is there a way to make as many as I want?
Thanks
There is obviously a problem with your table structures. If you post details of each of your tables with the relevant fields and explain how you are trying to relate them. We will try to help.
Oct 27 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.