[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/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Friday, October 28, 2005 10:35 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Is anyone migrating data?


Did a project (as a sub-contractor) like that a few years ago - Access 97
and Oracle. Must have done it very well because when I ask the main
contractor about it they say "still using it, they love it." The whole time
I'm writing it I'm thinking "why don't they just keep all the data in Oracle
all the time and use an Access front end for what this particular department
wants to do?"

I guess sometimes the politics of IT control are more important than
efficiency. BTW this client had a larger budget than any other client I have
ever worked for. They could have afforded to do it more sensibly.

John B.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com