Mark H
Lists at theopg.com
Wed Jul 2 09:06:48 CDT 2003
To check if ADO is used remove the tick from the reference and then compile the project (DEBUG - COMPILE) - if it compiles its not used. To check for unused tables is not so simple (I think) - Tables may be referenced in query, forms reports, modules and macros. I had a similar situation once and just bit the bullet and went through all the objects creating a list of referenced tables - anything not on the list got renamed and then the app got tested. It was very painful Good luck Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der Sent: 02 July 2003 14:55 To: accessd at databaseadvisors.com Subject: [AccessD] Application Review =Please Advise= Hi Group, (pardon my english...) I just started with my new job as a VB(A) developer/ analyst. Today is my second day and I've got a new project allready. I need to revise an Access 2000 application. It has 2 db's. DB1 has all the tables DB2 has all the forms and stuff and the tables from DB1 are linked to it. It uses DAO, but ADO is also checked in the references. I received all documentation of the app and I attached it to this mail...yes this is sarcastic since there is NO documentation, except for the few comments in the code...very few that is! There are no tables/queries added to the relationship form. Questions: - How can I check if there are tables/queries that aren't used? - How can I check if ADO is used somewhere along the DAO code? Any other tips are greatly appreciated!! Regards, VisualSander __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com