How do I make an Archive COA report that is identical to the COA for my active samples?
Information in this Article applies to:
When you look at samples from the archive area on the Main Menu you are looking at samples that are in an archives.mdb file. When you look at samples from the active area on the Main Menu you are looking at samples that are in the working.mdb file. When you first open up program.mdb and click on the Tables tab you will see many table names. Some of these tables have black arrows pointing to them. The tables with the black arrows do not reside in program.mdb but are tables in working.mdb that are "linked" to program.mdb. When you create an archive from the Utilities Menu – Transfer to Archive you are creating a new database with 10 tables that have the same structure as working.mdb. These tables are: SAMPLES, TESTS, TESTGROUPS, SUBMITTERS, MANUFACTURERS, Audit_Trail, QC_Pointers, QC_Samples, QC_TestGroups and QC_Tests. After you select an archive (from the Main Menu or from the Utilities Menu) or create an archive (Utilities Menu) the system automatically links the tables from the archives.mdb to program.mdb. Microsoft Access cannot have two tables linked with the same table name. The working.mdb file is always the first database attached to program.mdb and the archives.mdb file is always second. Therefore the tables in the archives.mdb when they get attached get renamed with a suffix of 1. So you will now have a SAMPLES table and a SAMPLES1 table and so forth. You know that the SAMPLES table is from working.mdb and the SAMPLES1 table is from archives.mdb.
If you have a report that you use in the active system that you would like to be able to print from the archive area follow these steps:
You are done creating an archive report that is identical to your active report. Exit the database and test your new report.