Microsoft Access - Copy Tables and Objects

Question

Hello,

How would I copy a database table along with associated forms and reports to a new table within a database, as opposed to creating a new table and the necessary forms and reports. I track service requests annually, and would like to set up the table and objects using copies of the old files.

No luck with import or export, or copy/paste when pasting to a different table.

Is this possible or must I reinvent the objects from scratch?

Thanks,

Walt N

Answer 1

Seems like there should be a better way, but I can't seem to figure out how to copy/paste or import/export objects from one table to another within the same database.

The better way is to not have a table per year but add a field for year and use criteria in your queries.

Answer 2

I agree with Carl, creating a new table and then resourcing all your reports and forms is not the best solution. 

Create a query for currentyear data and source your forms and reports to that query. Then each year you just change the criteria for that query and you are done.

Answer 3

Hey Bill,

Makes me wonder if I'm taking the right approach.

I was hoping to use the same database with a separate table, i.e. 2011, 2010, 2009, after creating a table for 2012. All existing tables, i.e. 2009, 2010, 2011, have the same forms and reports. In the past I've created the objects for each new table.

Seems like there should be a better way, but I can't seem to figure out how to copy/paste or import/export objects from one table to another within the same database.

Could I import to a new database and then import back to the original, or does that even make sense.

Thanks for your help and advice.

Walt

Answer 4

Walt - There should be no reason why you can't just import the table and objects into a new database as long as you have the same or newer version of Access installed.

When you import a table you have the option to import the structure only. That is probably what you want in this case.