I have a database in access for using from VB6. In my access file I use many relationships. I use something for doing back up of my database frequently for preventing data loss. Every year many data added to this database (app50000). For maintaining the program at the best performance I want to archive the older data.
What I have to do?
I want to add the power of using these archived files in later. Then when user want to use data from 2008 can be accessed through application.
Can anyone get me to the right path?
Thanks in advance