Can I duplicate the structure of a database, queries and reports

[Guest]

I need to duplicate the structure and rename a database and the related
queries / reports. My database is now "xxx-2005". I need to have the same
structure but have it named "xxx-2006". This is data relating to different
years in a business and the data should be separated for various reasons. The
data from 2005 would remain and the 2006 database would be empty and ready
for data entry. The database contains the data file, queries, forms for data
entry, and reports.

How is the best way to do this without replicating or building from scratch?

 

[Rick Brandt]

I need to duplicate the structure and rename a database and the
related queries / reports. My database is now "xxx-2005". I need to
have the same structure but have it named "xxx-2006". This is data
relating to different years in a business and the data should be
separated for various reasons. The data from 2005 would remain and
the 2006 database would be empty and ready for data entry. The
database contains the data file, queries, forms for data entry, and
reports.

How is the best way to do this without replicating or building from
scratch?

Create a new blank file and import all objects from the existing file. In the
import options you can choose "definition only" for the tables so the data will
not be copied.

 

[Guest]

Create a new blank file and import all objects from the existing file. In the
import options you can choose "definition only" for the tables so the data will
not be copied.

Thanks and the duplication did work. However when I run a query/report/etc
it runs against the old (2005) file/database and not the 2006. The 2006
database / file / table is empty and the results are from the 2005 file. I
have renamed the files/tables/queries/reports before running anything.

Do I need to go in and redirect each to the 2006 file? What is the best way
to point to current file and data?

 

[Ron2005]

Are your tables in a separate mdb from the forms and queries?

Did you import the queries etc into the new version and run them from
there?

 

[Ron2005]

If the tables are in the same mdb as your forms then everything needs
to be duplicated and you run from the new mdb OR you have to change
the references to the tables to make them links to the now separated
tables mdb.

If the tables and forms were in separate mdbs then you either need to
also duplicate the