[AccessD] Access 97 Architecture with Oracle DB

Any chance they will upgrade the version of Access itself to A2K or AXP?  

Doing that gets a common version of ADO installed. (your other email)

As for how to continue new dev, you might be on the right track - new MDBs
to contain all the new code and code that opens forms in "the other" db as
required.  I know I would be very hesitant to just start adding new stuff in
the old db.  In fact you could, as you look at each object and get it
upgraded, move that object into your new db.  Unfortunately you could run
into circular references here.  I am not sure (never tried it) whether you
can reference MDBX from MDBY and then reference MDBY from MDBX but I suspect
that Access would complain.

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 Mark Breen
Sent: Monday, January 17, 2005 6: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