[AccessD] Access 97 Architecture with Oracle DB

Hello Drew,

Not unless they are renamed themselves 02.ie and are a telco in Dublin :)

Mark



On Mon, 17 Jan 2005 10:08:03 -0600, DWUTKA at marlow.com <DWUTKA at marlow.com> wrote:
> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>