Mark Breen
marklbreen at gmail.com
Wed Jan 19 10:20:59 CST 2005
John and Marty, Thanks for that, good advice from both of you. I am only a cog in the gears here, but certainly they will have to follow some path. I was told today that there are actually 1000 tables in the db :). Mark On Mon, 17 Jan 2005 11:07:56 -0800, MartyConnelly <martyconnelly at shaw.ca> wrote: > You might want to pick up a copy of Total Access Analyzer from FMS > at least it will document what is going on and list dead code and unused > objects > > http://www.fmsinc.com/Products/suites/tadeveloper.asp > > Mark Breen wrote: > > >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 > > > > > > -- > Marty Connelly > Victoria, B.C. > Canada > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >