Re: Asking for help on breaking down table to smaller tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hello,

I have a database with the same problem. It contains one primary table

with a whole 121 fields. I know that is way too many. Most of them
could
be broken down into their own seperate tables, which is what I want to
do.
Unfortunately, the Table Analyzer in Access does not accomplish what I
need
because it generates a new Primary key for each new table and limits
each
new table to only 15 fields. Some of the new tables need up to 25
fields,
and each record in the new table will relate to its own unique record
in the
original table, so I want the same primary key for each new table
linked
through the table relationships with referential integrity enabled.


I have looked at the websites provided in the previous posts and
unfortunately what I need is a tutorial on how this normalization
can be done in Access, not a lesson on the concept. Short of copying
the data manually into new tables, I can't think of anything that
wouldn't result in data loss.


--
Silence2150
.

Relevant Pages

  • Linked Oracle tables ... losing primary key
    ... that asks you to select the field that represents the "unique record ... In the course of working with the Access database, ... randomly "loses" the primary key information that it had on a given table. ... I don't know if Access is doing it, or ODBC is doing it, but you can see it ...
    (borland.public.delphi.database.ado)
  • Re: problem using identity column as primary key
    ... >> I am thinking of creating an identity column to use it as primary key ... More and more programmers who have absolutely no database training are ... the gap in the sequence is not filled in and the sequence ... vin CHARNOT NULL REFERENCES Motorpool); ...
    (microsoft.public.sqlserver.programming)
  • Re: Updating the SQL key value
    ... before creating the database, by the time I've come to pick a primary key, ... articles, each of which must be issued under a particular licence (e.g. ... GPL GNU General Public Licence http://www.gnu ... ...
    (comp.lang.php)
  • Re: Concatenate and Null Values -- Features
    ... Tony Toews dislikes cascade deletes as well as cascade updates, ... fence regarding the use of natural versus surrogate (autonumber) keys. ... Database Normalization Tips ... For optimal database design and performance, the primary key of a table ...
    (microsoft.public.access.reports)
  • Re: Option groups, radio buttons and reports...oh my!!
    ... designing a 'questionnaire' database of using separate columns for the ... referencing the primary key of the Questions and Answers table. ... composite primary key of QuestionAnswers. ... a composite one of RespondentID and QuestionID; ...
    (microsoft.public.access.gettingstarted)