Table Wizard corrects things that aren't wrong

G

Guest

I have a rather large db I'm trying to normalize w/ the table analyzer. It
comes up
with 10,000 records that it wants to change because it thinks they're data
entry mistakes. They're not. It's a zipcode table of all the US
States|cities|zips I downloaded. Is there a registry entry where I can tell
this thing not to make the
corrections? It would be a useful tool if it weren't for that annoying
feature which apparently can't be turned off. Thanks.

Dave
 
G

Guest

Hi David

Anyone working on (developing) a database with 10K+ records should really
understand the process of normalising a DB. Please don't missunderstand I am
not being rude but you may be better - if you don't know how to do it
yourself - asking an outside person to look at the DB for you and give some
advice.

There are many people on this site who work for outside companies (I am not
one of thee by the way) who may be able to assist.

But if you were to give a details explanation of what yyou are trying to
achieve and some details of the table fields involved I'm sure someone would
be able to offer some constructive advice here for free.
 
J

John W. Vinson

I have a rather large db I'm trying to normalize w/ the table analyzer. It
comes up
with 10,000 records that it wants to change because it thinks they're data
entry mistakes. They're not. It's a zipcode table of all the US
States|cities|zips I downloaded. Is there a registry entry where I can tell
this thing not to make the
corrections? It would be a useful tool if it weren't for that annoying
feature which apparently can't be turned off. Thanks.

Dave

I've only used the table wizard a couple of times... and I was NOT impressed.
My bias is showing, I'm sure - I've been normalizing tables since 1985 or so,
and I'm pretty good at it - but I found some of the wizards suggestions
downright absurd.

I can't suggest how to tame the wizard, but I'd use its suggestions only in an
advisory capacity, and with a peck of salt at that.

John W. Vinson [MVP]
 
G

Guest

Wayne:

The wizard would accomplish a lot of work without that annoying feature
that renders it useless, irregardless of whether "I know what I'm doing" or
not.. and as far as paying someone to look at it. Are you paid to post those
things?.. and since when is usage of a wizard proof of incompetence?

John:

I agree the choices it made were ridiculous, but you CAN turn that
feature off and design it yourself (which is what I did). It's the choices it
makes to correct your data entry errors that are ludicrous... nothing like
someone assuming you're a brain dead nitwit (Wayne?). Thanks for the answers.

Dave
 
T

Tom Wickerqueer

John

the only thing that you've been doing since 1985 is your mother

if you knew anything about normalization; you'd be using SQL Server right
now
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top