Hi all, I am working on a project to revise a database that was built previously by another person. One of the table will be retire. What is the best way to do this so that I don't lose all the historical data that was linked to the table but make sure it will not be used going forward. The following up question is the data was originally imported from an Excel spreadsheet where some of the fields was a numeric value, and later switched to a string value in Access to denormalized all the tables. Should I imported all the data to a new Access database or fix all the bugs?
Thank you so much.