code to copy a table, gyery and form

E

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...
 
B

Bob Miller

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.
 
Top