Renaming Tables

[sh3498]

I have about 100 queries set up that are using the same table, but pulling different data. As I roll into next year, I want to use the same database with the same queries but I want to rename the table 2003 (from 2002). When I rename the table, some of the queries recognize the new table and work fine. Most of the queries just cannot find the table and do not work. What can I do????

Stacy

 

[Jack Cowley]

I do not know why you need to do this, but it sounds like your database is not normalized. You should be able to continue adding records to your current table(s) and still show the data that you want in your forms/reports. I suggest that you look very carefully at your structure and set up your database so that you do not have to do what you are doing now.

To answer your question - To do what you want you should purchase a program like Find and Replace from Rick Fisher as this will do what you want. My suggestion is to fix the database so that you do not have this problem every year.

hth,
Jack