Auto table name change in Access queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grasshopper - 27 Mar 2007 04:04 GMT

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 -

Reply to this Message

Ken Snell (MVP) - 27 Mar 2007 04:31 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> Do anyone know how to disable automatic table name change in Access
> queries?
[quoted text clipped - 10 lines]
>
> - Grasshopper -

Reply to this Message

Grasshopper - 27 Mar 2007 05:05 GMT

Great, thank so much for your help Ken!

- Grasshopper -

Reply to this Message