Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Vista Newsgroups > Vista hardware & devices

Vista - ACCESS 2003 Linking Tables Roadblock- PLEASE HELP!!!!!!!

Reply
 
Old 06-19-2008   #1 (permalink)
Jana


 
 

ACCESS 2003 Linking Tables Roadblock- PLEASE HELP!!!!!!!

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!

My System SpecsSystem Spec
Old 06-19-2008   #2 (permalink)
Curious


 
 

Re: ACCESS 2003 Linking Tables Roadblock- PLEASE HELP!!!!!!!

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!
My System SpecsSystem Spec
Old 06-19-2008   #3 (permalink)
David B.


 
 

Re: ACCESS 2003 Linking Tables Roadblock- PLEASE HELP!!!!!!!

I would suggest repost in an Access group as this has nothing to do with
Vista hardware.

--

----
Crosspost, do not multipost http://www.blakjak.demon.co.uk/mul_crss.htm
How to ask a question http://support.microsoft.com/kb/555375



"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!
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Access 2003 Microsoft Office
Implementing hyperlinking in SQL. (Linked tables to Access frontend.) .NET General
Help!! ACCESS 2003 linking tables Vista General
More on the Vista Service Pack 1 drivers roadblock Vista hardware & devices
Microsoft Office 2003 compatibility - Specifically - Access 2003! Vista General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46