I have a database that I'll have to update each day, records going up to the thousands. Old records will be updated accordingly and new ones will be added in. The data format will either be an excel sheet or a .csv, maybe tab delimited.
My question is, is there a way to set up Access to enforce checks and balances in regards to the integrity of the data? If some user accidentally imported an older file, it could throw the database out of whack. Do you guys have any suggestions on how to move forward?