Auto table name change in Access queries

  • Thread starter Thread starter Grasshopper
  • Start date Start date
G

Grasshopper

Do anyone know how to disable automatic table name change in Access
queries?

Currently, I am testing a set of 30 queries in an Access database and
need to have these 30 queries run on different tables, for example,
tblA, tblB, and tblC. I have all 30 queries built using tblA. I
wanted to test the data in tblB, so I renamed tblA to tblA_BK and tblB
to tblA. However, when I ran the queries, some queries are referring
to tblA but some are referring to tblA_BK. Why it that? How to
provent this from happening?

Thank you in advanced for your help.

- Grasshopper -
 
That is done by Name AutoCorrect, which is notorious for causing corruption
in databases at times.

See Tools | Options | General ---- there you can turn it off.
 
Back
Top