Modify Multiple Queries/Forms/Reports to use New Table

[CamoCat]

Sorry ... completely new to access. I need to modify multiple Queries, Forms and Reports to reflect a new Table. Can this be done individually or as a batch ... and how is this done? Many thanks.

[isladogs]

If you have Name Autocorrect options ticked, Access should update the table references after renaming the table.
However it won't update any references in SQL statements.

Also as name autocorrect doesn't always work as planned, you should
1. Make a backup First
2. Check all relevant items afterwards - the dependency checker tool should help
3. Switch off name autocorrect afterwards

[Micron]

Doing it as a batch via code could be more work than it's worth. For me, the lower limit would be about 24 of each because each object requires its own procedure. I have to wonder if the fact you didn't see the need for this table at the outset means that your db schema isn't properly normalized. That is a common cause for this sort of issue.

[CamoCat]

If you have Name Autocorrect options ticked, Access should update the table references after renaming the table.
However it won't update any references in SQL statements.

Also as name autocorrect doesn't always work as planned, you should
1. Make a backup First
2. Check all relevant items afterwards - the dependency checker tool should help
3. Switch off name autocorrect afterwards

Thanks for the reply. These are difficult times. Nice looking website ... Take care. :-) [CamoCat]