Have a db with over 25k records....Yes, I know...
anywho...need to archive older records.
I did a make table query to keep it to 2 yr records.
Put the table back with less records keeping same name so I don't have to change all the forms, queries, etc.
Well,, I get to 1 of the forms which contains a subform which contains this table and I am not able to update the table.
After researching,,,I see that the make-table more than likely caused this.
My question...what is the best way to remove all these records without causing data integrity issues for its use elsewhere? It would be close to 19k records....not gonna happen manually