Bug in Access 2003?

[Johnny Drama]

I'm wondering if anyone knows if this is a bug or I went about something the wrong way which is now causing me some grief.

I built my tables, queries, and forms and then realized that I hadn't named them to make them easily identifiable, i.e., tblCycle, tblProcess, qryTesting and so on. I went back and renamed Cycle to tblCycle and so forth.

Now when ever I go to use a report wizard to generate a report, the query that is automatically generated to pull the data from the table is created using the original table name, i.e. Cycle instead of tblCycle.

Anyone ever experienced this or heard of this happening?

 

[statsman]

I have noticed this as well.

However, if you have a table named Alpha and you change the name to Beta, it will list the table in the bar at the top of the screen as Alpha when working on a (lets say) query.
Despite this, it is in fact using the table Beta as you requested.
Seems Access has a long memory.

 

[jwhite]

It can be problematic when changing objects names. It cannot be assumed that if you change a table name, all references to that table name will be modified as well. An excellent tool for this is: Find and Replace (a development tool) for Microsoft Access