Is it possible to take an existing Access Database and delete previous data entered to coincide with the start of the new fiscal year without having to rebuild from scratch?
That is to say, there are some new fields that need to be added, but the powers that be don't want to have to take the time to build it from the bottom up again, but also don't want the old data in it so that the first entry will start with ID 1 instead of ID 2501.