Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Table Analyzer Wizard - Dialog Size

Discussion in 'Information Technology' started by John Saunders, Oct 29, 2005.

  1. John Saunders

    John Saunders
    Expand Collapse
    Guest

    I've just done an analysis of a table which I believe was originally
    generated from several other tables with relations between them. The idea
    was to have the table analyzer wizard reconstruct the original relations for
    me.

    The problem is that it's generated over 20 tables, some of them including
    single columns (first name or last name, for instance). I'd love to drag the
    columns to the correct tables, but I can't see them!

    This dialog is tiny - maybe 800 x 600, I don't know. It's also not resizable
    and can't be zoomed.

    Is there any way to get a better view of what's going on?

    Thanks,
    John Saunders
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    The table analyzer wizard isn't a terrible tool, however I wouldn't go with
    every recommendation it makes. For instance, it suggests a separate table
    every time it sees repeating data in a column - not necessarily a prudent
    idea. I also don't believe the wizard really gives you much flexibility in
    modifying the design of your database in its dialogs.

    I haven't run this wizard in a long time, so can't remember, but does it
    allow you to print out its recommendations? If not you could just write
    them out or use Alt-PrtSc and paste the screens into Word for a reference.

    In any case, all your design changes should be done in design view of each
    table and in the relationship window - i.e. from the database window.

    You could always post the details (not an attachment), i.e. a description of
    your current tables and relationships in the tablesdbdesign newsgroup and
    get some feedback there.

    eg
    tblEmployees
    EmployeeID - primary key
    FirstName
    LastName
    etc.

    tblDept
    DeptName - primary key
    EmployeeID - foreign key to tblEmployees
    etc.

    --
    Joan Wild
    Microsoft Access MVP
    John Saunders wrote:
    > I've just done an analysis of a table which I believe was originally
    > generated from several other tables with relations between them. The
    > idea was to have the table analyzer wizard reconstruct the original
    > relations for me.
    >
    > The problem is that it's generated over 20 tables, some of them
    > including single columns (first name or last name, for instance). I'd
    > love to drag the columns to the correct tables, but I can't see them!
    >
    > This dialog is tiny - maybe 800 x 600, I don't know. It's also not
    > resizable and can't be zoomed.
    >
    > Is there any way to get a better view of what's going on?
    >
    > Thanks,
    > John Saunders
     
  4. John Saunders

    John Saunders
    Expand Collapse
    Guest

    "Joan Wild" <jwild@nospamtyenet.com> wrote in message
    news:%23VRIAYK3FHA.4076@TK2MSFTNGP15.phx.gbl...
    > The table analyzer wizard isn't a terrible tool, however I wouldn't go

    with
    > every recommendation it makes. For instance, it suggests a separate table
    > every time it sees repeating data in a column - not necessarily a prudent
    > idea. I also don't believe the wizard really gives you much flexibility

    in
    > modifying the design of your database in its dialogs.
    >
    > I haven't run this wizard in a long time, so can't remember, but does it
    > allow you to print out its recommendations? If not you could just write
    > them out or use Alt-PrtSc and paste the screens into Word for a reference.


    I suspect that Alt-PrtSc would just print out the visible portion of the
    dialog.

    > In any case, all your design changes should be done in design view of each
    > table and in the relationship window - i.e. from the database window.
    >
    > You could always post the details (not an attachment), i.e. a description

    of
    > your current tables and relationships in the tablesdbdesign newsgroup and
    > get some feedback there.


    Thanks, Joan, but the details are proprietary, so I can't post them. I think
    that it used to be a grandparent - parent - child arrangement, now flattened
    down to the child level.

    If only they'd let me resize the dialog, I could actually use it!

    Microsoft, please eliminate all fixed-size dialogs in your products!!!


    John
     

Share This Page