Question Archiving

[blueanchor]

from time to time I need to delete records of a simular type but I do not want to delete them for good how can I delete these records to an archive table

 

[Mike375]

Here is a couple of ideas for you. Firstly, you need something in a field to indentify the records to be moved.

Then make an Apend query based on the field entry for the marked records. The Apend query appends the records to another table that is the same structure as the original table.

Make a a Delete query usng the same field entry that was used by the append query. You then have either a macro or code run the Append query and then run the Delete query. You have the Warnings turned off at the start of the macro or code and then turned back on at the end.

The other way to do it and the way that is usually recommended is have queries that are based on the table not display the records. The entry in a field to mark the records would be the criteria.

 

[Mike375]

Both at 10.04 pm, Sydney Australia time and the same response as well