Copying Database Structure

[LBA]

Is there a way when you have copied a database structure (but not the data)
to rename the tables and have those reflect in all the queries, forms and
reports?

 

[Jeff Boyce]

Why? Why would you need a new table with a new name with the identical
structure of another table?

This is a common approach when using a spreadsheet, but it rarely works well
when using a relational database (e.g., Access).

If you'll provide a more specific description of your situation and why you
think you need "duplicate" tables, folks here may be able to offer more
specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Arvin Meyer [MVP]]

Is there a way when you have copied a database structure (but not the
data)
to rename the tables and have those reflect in all the queries, forms and
reports?

With a utility like Speedferrett or Find & Replace:

Rick Fisher's Find & Replace

http://www.rickworld.com/products.html

and SpeedFerrett

http://www.speedferrett.com