John Bartow
john at winhaven.net
Fri Oct 28 10:52:36 CDT 2005
It sounds like a necessary method that your working on. My app was used by the same organization as the IT staff and on the same network the Oracle DB was connected too. Oh well, it was good money :o) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Friday, October 28, 2005 9:51 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Is anyone migrating data? This client analyzes parts repair for the US Navy, specifically pieces of aircrafts for three repair depots. They get a large (denormalized) table from the Navy with each part, information about the part, the repair depot, costs to repair, repair cycle times, order cycle times, how many are on order and quantities in the order or repair process etc. - all in one table. Their task is to analyze the whole process, determine which are being repaired but aren't needed because they have plenty on hand, which they shouldn't even be ordering because they have plenty on hand, which they SHOULD be ordering / repairing etc. This application is already written, but the person who migrated the data the first time did not document or save the process. Now they need to load up new (recent) data and don't know how. This firm is a consulting firm, who just takes the data, massages it to get it into a form they can deal with, then analyzes it and sends reports to someone in the NAVY. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/