I suspect that the answer is maybe. It will depend (mainly) upon exactly
what you do with the Table Analyzer wizard. If you give the wizard its
head, answering Yes to the main questions, at the end of the process it will
create a query (or queries) with the same name(s) as the table(s) on which
it(they) was(were) based. So your existing queries and forms should still
work, since their source data is still available from an object with the
same name.
The problem with this, IMHO, is that you finish up with lots of objects with
strange names, particularly if you are using the LNC (or any similar) naming
convention: eg. tblOrders will have been renamed to tblOrders_OLD, and there
will be new related tables for it (which you have the opportunity to name
with a meaningful name during the process; however, you will now have a new
query named tblOrders - and to comply with the LNC naming convention it
should be named qryOrders. If you do that manually after the wizard has
run, you will then need to revisit any existing queries or forms which used
tblOrders and replace that name with qryOrders.
Since you're asking now, it's probably too late for my most important peice
of advice, which is: get your table design correct before designing any
queries, form, or reports. Personally, I would only ever use the Table
Analyzer wizard if I had imported non-normalized data (most commonly from a
spreadsheet) and wanted to build a database using that data - I'd run the
wizard immediately after the import, and before doing anything else.
HTH,
Rob
PS. if you are using the LNC naming convention (or would like to), there is
an add-in written by Helen Feddema which does renaming for you. See item
75, "Renaming Database Objects" at
http://www.helenfeddema.com/access.htm
There's about to be a new version of that add-in, but it wasn't available
when I last checked that page - check at the bottom of that page to see if
it's been released yet.
PPS. look carefully at the entries which the wizard suggests should be
corrected for typographical errors - I find that it's extremely bad at this!
