[AccessD] Application Review =Please Advise=

Hale, Jim jim.hale at fleetpride.com
Wed Jul 2 09:29:28 CDT 2003


 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
Jim Hale

-----Original Message-----
From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
Sent: Wednesday, July 02, 2003 9:11 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Application Review =Please Advise=


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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030702/727a2f96/attachment-0001.html>


More information about the AccessD mailing list