[AccessD] Access 97 Architecture with Oracle DB

Phew, okay, just checking.  Making sure I'm not having someone go behind my
back.  I've been fighting tooth and nail to do something with the project
that sounded just like what you are talking about.  It's a legacy system
from before I got here, and is a virtual nightmare!

Drew

-----Original Message-----
From: Mark Breen [mailto:marklbreen at gmail.com]
Sent: Wednesday, January 19, 2005 10:20 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com