code to copy a table, gyery and form

To achieve something rather complicated I need a code to copy a table name
Orders, query name OrderDetails and a form named Order to an empty database
called OffLineOrders. The databases are both in F:.
Then every once in awhile to copy the table Orders back to the actual
database called AllOrders under a different name so it doesn't effect to the
actual table. The databases are both in F: Orders.
Planning to do an append query after that.
I'm quite new to access, so every piece of help is more than wellcomed.
Thanks if anyone...

Create a Macro and use the TransferDatabase function for each object you want to transfer. The source database and destination database can be anywhere to which your computer is connected. Press F1 in each field of the Action Argument that you don't understand.

Originally Posted by elli

To achieve something rather complicated I need a code to copy a table name
Orders, query name OrderDetails and a form named Order to an empty database
called OffLineOrders. The databases are both in F:.
Then every once in awhile to copy the table Orders back to the actual
database called AllOrders under a different name so it doesn't effect to the
actual table. The databases are both in F: Orders.
Planning to do an append query after that.
I'm quite new to access, so every piece of help is more than wellcomed.
Thanks if anyone...