Access external table

[kornelius]

From my open database (db1) I want to delete all records from an not-linked table (table1) in an external database (db2). After that I want to add all records from db1-table1 to db2-table1. I am looking for the vba (Sql) code.
Thanks
Kornelius

[orange]

Link the Table1 in db2 to your db1. Why not use the LinkedTableManger Tool in Access?

[kornelius]

The target is to create each month an image of my existing database. Therefore I want to load the tables in an external database. The image lives an independant life and can be consultated to verify the modifications which toke place during the next month.
Thanks for your advice
Greatings
Kornelius

[orange]

Are you saying, over the course of a year , you will have 12 separate and distinct databases. Each represent a month's activities?

Perhaps you could explain your situation more.

You can have a database, say MyTemplate.mdb.
This can have all your table structures (without any data) in the template.
You can take a copy of your template and link to tables in any or several existing databases and link the tables, or import data into the template tables.

You can also have a transaction log into which you would store all transactions/modifications with a unique number and time. This can be interrogated at any point to determine the status.

It all depends on what you want to accomplish and then look at various options.

[kornelius]

Thanks for your intervention and the explanation
I 'll give you some more explanation.
The database considers an HRM-database. At the end of the month the end-user takes an image of his database (That 's the part I want to automate). The next month he makes his modifications needed in the main database; so he can always consult the old situation in the image if necessary. At the end of this month he takes another image again which will overwrite the old-one. That means at any time one main database and one image database.

To autmate this procedure I want to load the tables in an extern database. I think it 's possible by SQL.

Thanks and greetings
Kornelius

[orange]

And what if he wants to know the details(image) of something 2 or 3 months ago?

[kornelius]

When the end-user takes the image that means that he will accept the actual situation that will be used to calculate the salary based on presence, sick-leace etc. This will be the base of the next month. During the next month he must be able to retun at the situation at the start of the month.

Thanks
greetings