Windows Vista Forums

Microsoft ACCESS 2003 HELP!!!!

  1. #1


    Jana Guest

    Microsoft ACCESS 2003 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

  2. #2


    Kerry Liles Guest

    Re: Microsoft ACCESS 2003 HELP!!!!

    Access is not very robust - especially with a large number of tables and/or
    a complex schema (such as it is).
    You didn't mention whether free was a consideration, but MySQL might be
    worth looking at. It has quirks too, but a zillion people use it (since it
    is free).

    HTH


    "Jana" <Jana@xxxxxx> wrote in message
    news:0513215C-AABB-41FB-822A-62783C1D53CB@xxxxxx

    > 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

Microsoft ACCESS 2003 HELP!!!!

Similar Threads
Thread Forum
Restricting VPN Access in SBS 2003
Is it possible to restrict access for VPN clients to a single directory in SBS2003? Perhaps I am using the wrong technique. We have a remote...
SBS Server
Access 2003
Hi all! I have been using access to keep a record of the books I have read (NO MOCKING PLEASE! :sa:). Anyway... I use two tables: "Authors"...
Software
MS Access 2003 & VISTA
I have a MS Access database which I've developed using MS Access 2003 on an XP Machine. It has a Front-End which I give to each user and a single...
Software
outlook web access microsoft exchange service 2003
I have a problem where when someone sends an email and set a calendar date it is always off an hour. How can this be fixed?
.NET General
using microsoft office 2003 allong side of microsoft works with Vista Home Premium?
Have a Dell laptop that has Microsoft Works installed. Want to install Microsoft Office Professional 2003. Do I need to uninstall Works prior to...
Vista General
Access issues with Microsoft Access
I finally decided that I have some time to allow for problems, and updated my XP professional OS to Vista business on my laptop. I can see and...
Vista networking & sharing
Microsoft Office 2003 compatibility - Specifically - Access 2003!
We had to purchase a new computer due to lightning hitting our office. The only one we could find that met our requirements has the Vista OS. We...
Vista General