Roly Reefer
Registered User.
- Local time
- Today, 20:55
- Joined
- Jan 28, 2005
- Messages
- 37
Hi,
In Access 2003 when you rename a table any queries that the table is in will be renamed aswell, which is usually very useful.
However, is there a way to turn this property off, because I am trying to run over a hundred of the same query that use different tables? In Access 2000 I renamed the tables and used the same query, because it is much quicker, but I have just noticed that the data I am extracting is inaccurate, because when I undo the rename, the table names change in the query.
I will be very grateful for any help.
All the best,
Roly
In Access 2003 when you rename a table any queries that the table is in will be renamed aswell, which is usually very useful.
However, is there a way to turn this property off, because I am trying to run over a hundred of the same query that use different tables? In Access 2000 I renamed the tables and used the same query, because it is much quicker, but I have just noticed that the data I am extracting is inaccurate, because when I undo the rename, the table names change in the query.
I will be very grateful for any help.
All the best,
Roly
