Hi all,
I have an Access97 DB. It's made up of many tables etc, which are becoming slow on loading due to the number of entries stored in each of them. It's therefore time to do a dump. I simply want to end up with a replica of the back end that only contains certain tuples from certain tables.
Each table contains a key field, of which the last three characters are "/99", "/00", or "/01". I want to leave only the tuples with "/01" in my "active" database, and put only the tuples with "/99" and "/00" into my new archive database. The table structure etc in the archive db should remain the same as what it is currently.
I am at a loss as to how best approach this however. Are there any shortcuts I could be using, or any particular approach I should be taking?
Thanks in advance.
I have an Access97 DB. It's made up of many tables etc, which are becoming slow on loading due to the number of entries stored in each of them. It's therefore time to do a dump. I simply want to end up with a replica of the back end that only contains certain tuples from certain tables.
Each table contains a key field, of which the last three characters are "/99", "/00", or "/01". I want to leave only the tuples with "/01" in my "active" database, and put only the tuples with "/99" and "/00" into my new archive database. The table structure etc in the archive db should remain the same as what it is currently.
I am at a loss as to how best approach this however. Are there any shortcuts I could be using, or any particular approach I should be taking?
Thanks in advance.