[AccessD] Application Review =Please Advise=

Roz Clarke roz.clarke at donnslaw.co.uk
Wed Jul 2 09:11:11 CDT 2003


You could speed up your hunt for references to the tables using Find and
Replace or another similar tool.

Roz

-----Original Message-----
From: Mark H [mailto:Lists at theopg.com] 
Sent: 02 July 2003 15:07
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Application Review =Please Advise=

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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list