Regd index limitation for a table

[Ravi]

Hello All,

At present i am dealing with a total of 106 tables. The
information being stored is related to a client for a
particular year. Like this i have to store n number of
clients with 7 yrs data maximum. I am facing a problem
while making relationships to the tables. The error
message is as follows:

"The operation failed. There are too many indexes on table
x. Delete some of the indexes on the table and try the
operation again."

Can somebody throw some light on this as i am new to this.
The matter is most urgent.

Please revert back with some information.

 

[Tim Ferguson]

At present i am dealing with a total of 106 tables. The
information being stored is related to a client for a
particular year. Like this i have to store n number of
clients with 7 yrs data maximum.

This, frankly, is a huge number of tables for an Access application. It
suggests either (a) that it's highly sophisticated and you should be
answering questions here, rather than asking them; or (b) that there are
some serious design problems, with data stored in tablenames rather than
field values. Do you have tables like DetroitSales1999, DetroitSales2000,
DetroitSales2001... and so on?

B Wishes


Tim F

 

[TC]

This, frankly, is a huge number of tables for an Access application. It
suggests either (a) that it's highly sophisticated and you should be
answering questions here, rather than asking them; or (b) that there are
some serious design problems, with data stored in tablenames rather than
field values. Do you have tables like DetroitSales1999, DetroitSales2000,
DetroitSales2001... and so on?

Well put!

Ravi, if you're reading this, do a google search on "Q100139". This will
lead you to an article on "database normaliztion". You may find some hints
in there.

TC