Auto table name change in Access queries

[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 -

 

[Ken Snell \(MVP\)]

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.

 

[Grasshopper]

Great, thank so much for your help Ken!

- Grasshopper -