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.

--

Ken Snell
<MS ACCESS MVP>

"Grasshopper" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 -
>

Great, thank so much for your help Ken!

- Grasshopper -