Update a set of select queries to refence a different table

[vbevan]

Can anyone tell me how you batch change the table data is being selected from in a set of queries to a different one in Access 2002 (if it's possible)?

I had a table "Data2008" that has 50+ select queries running off it. Now I have the latest table "Data2009" and I want to update all those queries to point to that table instead, without having to go into each one and do it manually. Both tables have exactly the same fields types etc.

Thanks.

 

[khawar]

you should not be maintaining seperate tables for each year you can use one table for all years and then data can be filtered for each year whenever required

 

[vbevan]

you should not be maintaining seperate tables for each year you can use one table for all years and then data can be filtered for each year whenever required

I'll give that a try, I was just worried about the performance hit on have that much data in one table (10 yrs so far, each 50 data fields and 40000 records) but I'll give it a try and see how it goes.

For now I have a select query that selects the table and all the others run off that select query.

Cheers though.