![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| 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. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| Guest | Help!! ACCESS 2003 linking tables 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! |
My System Specs![]() |
| | #2 (permalink) |
| Guest | Re: Help!! ACCESS 2003 linking tables 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! 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 |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Access 2003 | Microsoft Office | |||
| Implementing hyperlinking in SQL. (Linked tables to Access frontend.) | .NET General | |||
| ACCESS 2003 Linking Tables Roadblock- PLEASE HELP!!!!!!! | Vista hardware & devices | |||
| Not able to access SBS 2003 PC from Vista 64-bit | Vista networking & sharing | |||
| Microsoft Office 2003 compatibility - Specifically - Access 2003! | Vista General | |||