Removing unnecessary references

  • Thread starter Thread starter Silvester
  • Start date Start date
S

Silvester

Is there any way to check if there are unnecessary references being used for
a mdb ? eg: if a reference is made to MS-Calendar control mscal.ocx but it
is never really used during the running of the mdb ?

I'd like to clean out unnecessary refs in my mdb.

Thanks for any advice
 
Silvester said:
Is there any way to check if there are unnecessary references being used for
a mdb ? eg: if a reference is made to MS-Calendar control mscal.ocx but it
is never really used during the running of the mdb ?
Click to expand...

The Access 97 default references are:
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.5x Object Library

The Access 2000 default references are:
Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
or
Microsoft DAO 3.6 Object Library

The Access 2002 default references when the MDB is created in Access
2000 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

The Access 2002 default references when the MDB is created in Access
2002 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 Library.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Thanks Arvin & Tony,

I tried removing refs and compiling and the number of references has come
down from 17 to 5 ! The app seems to work normally.

Is this method reliable or do you think I'm going to face any nightmares
after distribution ?
 
Silvester said:
Thanks Arvin & Tony,

I tried removing refs and compiling and the number of references has come
down from 17 to 5 ! The app seems to work normally.

Is this method reliable or do you think I'm going to face any nightmares
after distribution ?
Click to expand...

Reliable. If you can compile it cleanly then you didn't need it.

BTW what do you have that isn't part of the basic?

How do you get rid of troublesome references?
http://www.granite.ab.ca/access/referencetroubles.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Not part of the basic... well, somewhere along the way during development
the app needed ref to mscal.ocx, Lebans mousehook.dll, xmsconf.ocx,
appbar.dll, and some other scripting runtimes refs..

Thanks for the advice. I was able to wipe out over 10 unnecessary refs.
 
Silvester said:
Not part of the basic...
Click to expand...

Ah, ok. That's what I was wondering.
well, somewhere along the way during development
the app needed ref to mscal.ocx, Lebans mousehook.dll, xmsconf.ocx,
appbar.dll, and some other scripting runtimes refs..
Click to expand...

Yeah, stuff starts to creep in sometimes and you gotta roto rooter
them out.
Thanks for the advice. I was able to wipe out over 10 unnecessary refs.
Click to expand...

You're quite welcome.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top