Archiving...?

[Hellfire]

Hi all,

I am still looking for an effective way of archiving records from my db.

The data is not very important, but it would be useful to keep it for statistical purposes.

What I would like is a button, when the user click on the button, he/she should be prompted to enter certain criteria (in this case a period ie. from- and to-date.) Then there should be an OK/Next or whatever button, when the user click on this, the process should start by itself.

I do not care where the data is moved to, as long as it can be viewed later on. Preferably it should be stored in a new table that would be automatically created during the process. (within the same database.)

It would be usefull if the data that is "archived" could be automatically deleted from the working table.

Can anyone help me please??

Thanks

 

[Nero]

You could use an append query to append the data from your working table to an archive table. Then use a delete query to delete the contents of your working table.

 

[Hellfire]

Hi,

I have been told that before, that will sort out all my problems, the problem being, I do not know how to do that.

Can you please give me some advice? Point me in the right direction?

Thanks

 

[Nero]

Create a new table called tblarchive.
In the db window create a new query. In design view select your working table and select the fields that you want to append.
Right click in the query where the table is and chose the append query type. This will prompt you to enter the table which you want to append to ( your new table).
Create a new query and again select the fields that you want to delete the data from. Right click again and chose the delete query type. If you only want to delete certain records ,ie before a certain date then you need to add a line to the criteria.
On your form create 2 buttons with the wizard to run each of your queries.