Database conversion wizard looking for typos

C

Cheese

When I use the Access conversion wizard (through the Analyze Table feature)
to convert a flat database to a relational one, the wizard tries to look for
typos and suggest the "correct" entry instead of what is already there. You
can manually tell it to leave the entry alone, but this is cumbersome when
hundreds of records come up and it wants to change each one. I already know
each record is correct, none of them need any typos fixed. How can I convert
the database without having to deal with Access trying to fix what isn't
wrong to begin with?
 
A

Arvin Meyer [MVP]

Just a guess, but you could try turning off AutoCorrect on the Tools ...
Options ... General tab. On the Spelling tab, turn off all the options.

Since I design most of them from scratch, I haven't run into your problem.
It seems to me though that you could build your tables and a few append
queries and manually move the records faster than having to deal with each
one.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top