Forum Discussion
RAC1978
Apr 02, 2024Copper Contributor
Steps to remove certain date range of records in Access
I have a database with about 10 years of records. We only need two years of history in the current database. How can I move the older data but keep in case we need to review? Roberta
RAC1978
Copper Contributor
Skandel590 I will look into the steps of getting this done. I don't want to mess anything up..
I think you are saying to archive the table in the current database, then delete the unwanted records from the current database?
Skandel590
Apr 08, 2024Copper Contributor
RAC1978,
Unless I know the database structure I can not suggest much.
The solution I was suggesting was If your Database resides on server and your end users are MS access app with Linked table, below are option.
1) Create a duplicate table with different name, Run an append query to append data from the production table to the newly created archive table. Once data appended, you can delete the old records from the production table. However if the tables are relationships are not designed properly, that may not help. but you can try without messing.
2) Instead of keeping Database on Access, you can migrate to MSSQL (Of course express version which does not cost and free upto 10 GB Database) link the tables in Ms Access which can improve the performance.
If you can PM me the database relationship, How many tables, How many queries run on main form I may be able to assist.
Unless I know the database structure I can not suggest much.
The solution I was suggesting was If your Database resides on server and your end users are MS access app with Linked table, below are option.
1) Create a duplicate table with different name, Run an append query to append data from the production table to the newly created archive table. Once data appended, you can delete the old records from the production table. However if the tables are relationships are not designed properly, that may not help. but you can try without messing.
2) Instead of keeping Database on Access, you can migrate to MSSQL (Of course express version which does not cost and free upto 10 GB Database) link the tables in Ms Access which can improve the performance.
If you can PM me the database relationship, How many tables, How many queries run on main form I may be able to assist.