Table Analyzer Wizard - Dialog Size

[John Saunders]

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

 

[Joan Wild]

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.

 

[John Saunders]

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