Question change dependency of renamed Table/Query/Form?

[Arjuna80]

Hiyas

I'm new to Access, but had to make one new table (inside 1 mdb) for the company.
Now my question is:
There are Queries for the old table.
There is a new Form for my new Table.

How can i make the queries to get their information from my new table, instead from the old one?
May i just rename my new table to the old table's name, where all the queries get/got their info?

Version: Access 2000.

Thank you

 

[Galaxiom]

You can rename the new table if it has all the same field names as used by the queries.

Backup the whole database first in case of disaster.
Make a copy of the old table as a handy backup.
Delete the old table.
Rename the new table to the old table's name.

Whatever you do don't rename the original table. You must delete it.
If autocorrect is on, changing its name will trigger changing the name in the queries.

 

[Arjuna80]

OK, thank you very much.