<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] Application Review =Please Advise=</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2> I would compile first to make sure that the code works as delivered. Then uncheck the ADO reference and try compiling. If it compiles you know the ADO reference is not used. If it doesn't compile you know it broke because ADO code is used somewhere. BTW FMS has a database analyzer that can help you figure out the database. Good luck</FONT></P>
<P><FONT SIZE=2>Jim Hale</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Roz Clarke [<A HREF="mailto:roz.clarke@donnslaw.co.uk">mailto:roz.clarke@donnslaw.co.uk</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 02, 2003 9:11 AM</FONT>
<BR><FONT SIZE=2>To: 'Access Developers discussion and problem solving'</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Application Review =Please Advise=</FONT>
</P>
<BR>
<P><FONT SIZE=2>You could speed up your hunt for references to the tables using Find and</FONT>
<BR><FONT SIZE=2>Replace or another similar tool.</FONT>
</P>
<P><FONT SIZE=2>Roz</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Mark H [<A HREF="mailto:Lists@theopg.com">mailto:Lists@theopg.com</A>] </FONT>
<BR><FONT SIZE=2>Sent: 02 July 2003 15:07</FONT>
<BR><FONT SIZE=2>To: 'Access Developers discussion and problem solving'</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Application Review =Please Advise=</FONT>
</P>
<P><FONT SIZE=2>To check if ADO is used remove the tick from the reference and then</FONT>
<BR><FONT SIZE=2>compile the project (DEBUG - COMPILE) - if it compiles its not used.</FONT>
</P>
<P><FONT SIZE=2>To check for unused tables is not so simple (I think) - Tables may be</FONT>
<BR><FONT SIZE=2>referenced in query, forms reports, modules and macros. I had a similar</FONT>
<BR><FONT SIZE=2>situation once and just bit the bullet and went through all the objects</FONT>
<BR><FONT SIZE=2>creating a list of referenced tables - anything not on the list got</FONT>
<BR><FONT SIZE=2>renamed and then the app got tested. It was very painful</FONT>
</P>
<P><FONT SIZE=2>Good luck </FONT>
</P>
<P><FONT SIZE=2>Mark</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: accessd-bounces@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:accessd-bounces@databaseadvisors.com">mailto:accessd-bounces@databaseadvisors.com</A>] On Behalf Of Sad Der</FONT>
<BR><FONT SIZE=2>Sent: 02 July 2003 14:55</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: [AccessD] Application Review =Please Advise=</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi Group,</FONT>
</P>
<P><FONT SIZE=2>(pardon my english...)</FONT>
<BR><FONT SIZE=2>I just started with my new job as a VB(A) developer/</FONT>
<BR><FONT SIZE=2>analyst.</FONT>
</P>
<P><FONT SIZE=2>Today is my second day and I've got a new project</FONT>
<BR><FONT SIZE=2>allready. I need to revise an Access 2000 application.</FONT>
<BR><FONT SIZE=2>It has 2 db's.</FONT>
<BR><FONT SIZE=2>DB1 has all the tables</FONT>
<BR><FONT SIZE=2>DB2 has all the forms and stuff and the tables from</FONT>
<BR><FONT SIZE=2>DB1 are linked to it.</FONT>
</P>
<P><FONT SIZE=2>It uses DAO, but ADO is also checked in the</FONT>
<BR><FONT SIZE=2>references.</FONT>
</P>
<P><FONT SIZE=2>I received all documentation of the app and I attached</FONT>
<BR><FONT SIZE=2>it to this mail...yes this is sarcastic since there is</FONT>
<BR><FONT SIZE=2>NO documentation, except for the few comments in the code...very few</FONT>
<BR><FONT SIZE=2>that is!</FONT>
</P>
<P><FONT SIZE=2>There are no tables/queries added to the relationship</FONT>
<BR><FONT SIZE=2>form.</FONT>
</P>
<P><FONT SIZE=2>Questions:</FONT>
<BR><FONT SIZE=2>- How can I check if there are tables/queries that</FONT>
<BR><FONT SIZE=2>aren't used?</FONT>
<BR><FONT SIZE=2>- How can I check if ADO is used somewhere along the</FONT>
<BR><FONT SIZE=2>DAO code?</FONT>
</P>
<P><FONT SIZE=2>Any other tips are greatly appreciated!!</FONT>
</P>
<P><FONT SIZE=2>Regards,</FONT>
</P>
<P><FONT SIZE=2>VisualSander</FONT>
</P>
<P><FONT SIZE=2>__________________________________</FONT>
<BR><FONT SIZE=2>Do you Yahoo!?</FONT>
<BR><FONT SIZE=2>SBC Yahoo! DSL - Now only $29.95 per month! <A HREF="http://sbc.yahoo.com" TARGET="_blank">http://sbc.yahoo.com</A></FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>