Jana wrote:
Quote:
> I have a major problem. I am developing a database for a client that
> contains over 302 tables, all of which have thousands of rows. 301 of these
> tables need to be linked to the parent table, and all have the same primary
> key. However, I have recieved that evil error message that only 32 tables
> can be indexed. I have searched and searched, but cannot find a solution to
> this. I am desperate for any suggestions, even if it means taking avenues
> other than ACCESS 2003. The only requirements are that the database has the
> ability to be online, collecting data from other parties via some sort of
> form. Also, these tables must have full capabilities to be edited and
> controlled, not read-only. CAN ANYONE HELP ME??? There is a huge deadline
> coming in hours. Thanks!
You posted to a Vista newsgroup. Try on of the Access news groups like
microsoft.public.access.gettingstarted.
If your database has 302 tables my guess would be that there is a major
design flaw. But that's only a guess since you didn't give any specific
information about your table structure.
When you post to the access group I would suggest giving as much detail
as possible if you want a good answer.
gls858