[AccessD] Access 97 Architecture with Oracle DB

This wouldn't happen to be for Marlow Industries, would it?  <grin>  Sounds
like one of our systems.

Drew

-----Original Message-----
From: Mark Breen [mailto:marklbreen at gmail.com]
Sent: Monday, January 17, 2005 5:52 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 97 Architecture with Oracle DB


Hello All,

I have taken a contract with a client that are using Access 97 and
Oracle for an enormous system.

There are hundreds of tables, queries, pass through queries, linked
tables and all sorts of other stuff also in it.

There is no documentation at all, no inline comments at all anywhere! 
No framework of any sort and each form is created as a new form with
only small similarities to the existing ones!

Error handling amounts to on error resume next !

I am seeking your suggestions as to how to continue to develop this
system with the future in mind.  I am considering some way of using
the existing MDB to call new MDB's.  These new MDB's will be created
and developed in a more sytematic way.  Any comments you have on this
would be welcome.

The current archecture is Oracle BE, with Access FE, but with lots of
local data in the FE also.  At some stage in the future 12-18-24
months, they may overhaul the entire system, but in the meantime, we
have to continue working with what we have.

Thanks for your input.

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