Linking a table to another table in a Database

[pamit_1982]

Hi Friends,

I am currently working on a database called Tracker.

Just briefing you about history
my database was made in excel sheet and then simply imported to an access table called Integrated table1 at EOD.
all the queries thereafter designed were based on this Integrated table.
When I was told to refine this database I designed my own table and named it Tracker.
To mention Tracker also contains same data as in Integrated table.
Now my simple query is How to migrate these 50 odd queries which were based on Integrated table.
Should i change the Sql of each or link Integrated table to Tracker

Regards,
Access User

 

[gemma-the-husky]

if you can , you can just rename EOD to EOD_Old, and rename Tracker to EOD

this will/may be a problem if you have changed your field names, but otherwise will be OK

if tracker is a linked external table, you may need to relink it.

 

[amit82]

Thanks That is what i have Already Done..
Just needed to reconfirm what i have done
Amit