[AccessD] Is anyone migrating data?

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/




More information about the AccessD mailing list