Linked Table Manager macro

[James]

I am sending a new front-end version of a database out. There is a new
back-end table that I need existing data appended to. I am going to put the
new table "NewEmployee" in the front end and then run a macro or vb code to
execute the proccess below.

How do you tell access to move the NewEmployee table to the backend database
(which is located in the same folder), and then run the append query (which I
know how to create and it is also located in the new front-end db), and then
delete the old table, called "Emlpoyee", and rename the NewEmployee table to
"Employee"?

Thank you for your help,
James