Sounds like you need a major design change is required.
How about creating less tables that have to be linked and then have the
different Access forms you develop for some of the tables prefill in the
fields that contain the IDs and other information unique to the party that
is using the form.
"Jana" <Jana@xxxxxx> wrote in message
news:553C6F1A-E710-40AC-96BE-1DFB95DBCF46@xxxxxx
Quote:
> 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!