A NOTE for those few who may be merging the catalog database from 2005 with their customized catalog database for use in 2004 because they are staying with ACADE 2004 temporarily:
Among some of the differences between the pinlist table in 2004 and the one in 2005, the 2004 version uses some abbreviated field names such as CAT and MFG, while they are completely spelled out in 2005. If you use the procedure mentioned in this thread for merging the two catalogs, you will end up with a 2005 compatible pinlist. However, ACADE 2004 will not be able to access the pinlist table.
To use the newly merged catalog with 2004, you should take the extra step of using Access to rename the pinlist table in the newly merged database, copy a 2004 pinlist table into the newly merged database, and then overwrite the data in the 2004 pinlist table with the data from the renamed 2005 pinlist table, which can then be deleted. (If you followed the merge procedure mentioned in this thread, you will end up with a pinlist that contains your added pinlists from 2004 or earlier, plus the new pinlists in the 2005 database.)
- Jay
BTW, I noticed an error (duplicate pin number) in the 2004 pinlist that has been corrected in the 2005 pinlist. 😉