| | |
|
|
|
Removing unnecessary references |
|---|
| message from Silvester on 23 May 2004 |
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
|
| Arvin Meyer replied to Silvester on 23 May 2004 |
Just uncheck them 1 at a time and try to compile the database after
unchecking each one. If the reference is needed, the database won't compile,
and you'll get an error.
|
| Tony Toews replied to Silvester on 23 May 2004 |
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
|
| Silvester replied to Tony Toews on 24 May 2004 |
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 ?
"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:jog1b016k9amb08ohqu8v3k3m0gdt8t8f3@4ax.com...
|
| Tony Toews replied to Silvester on 24 May 2004 |
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
|
| Silvester replied to Tony Toews on 24 May 2004 |
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.
"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:bi53b016pg2c4qvjqe3v1pc1b73sff7a79@4ax.com...
|
| Tony Toews replied to Silvester on 24 May 2004 |
Ah, ok. That's what I was wondering.
Yeah, stuff starts to creep in sometimes and you gotta roto rooter
them out.
You're quite welcome.
Tony
|
|
Archived message: Removing unnecessary references (MS Access Forms)
