How to normalizing a Table?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Leo W (LeoW_at_discussions.microsoft.com)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 13:35:04 -0700

Hi,

I am a novice to Access 2002. I am working on a project that has grown
beyond my learning curve. What I have is a form with a Tab Control (7 tabs).
 I originally had planned on putting all the fields from each Tab into one
Table then use the Normalize wizard to slim down the database. However, I
ran into the following problem “The row you inserted in the grid exceeds the
limit of 255 rows (fields) for a table”. I know why this has happen but what
I was hoping to learn is a way to put all the fields that the team is
requesting and still use the normalization wizard. I was also wondering if
it would be a good idea to create a table for each tab and setup
relationships between the tables. I have tried this on a limited basis and
could not get it to work correctly. Any suggestions or pointer would be
greatly appreciated.

Leopold

Relevant Pages

  • Re: Ham Radio Projects" 1968 by Bert Simon Page 105.
    ... 104 ham radio projects for novice & technician. ... I remember a book like this published by Tab Books.... ...
    (rec.radio.amateur.boatanchors)
  • Re: new free tabs for guitar
    ... The point is that the learning curve for tab is very shallow, ... under their fingers. ...
    (rec.music.classical.guitar)
  • Re: Problem with Forms
    ... go to the Other tab on the property sheet and set ... test data through my forms and noticed out of habit I often hit the enter ... this database range from novice to less than novice. ...
    (microsoft.public.access.forms)