Reference Libraries and where they come from

[Guest]

Does anyone know where reference libraries in VB come from and are there any
ways to transfer them? We share databases here at work on a common drive
however the reference libraries I have are different from others and the same
for them.

 

[Rick Brandt]

Does anyone know where reference libraries in VB come from and are
there any ways to transfer them? We share databases here at work on
a common drive however the reference libraries I have are different
from others and the same for them.

All that matters are the ones that are "checked". The entire list is simply
every registered COM resource on your system and yes that will vary on every
computer.

If you open a brand new Access file and then look at the "checked" references
you will see the default ones that are always used. Those should be available
on any PC that has the same version of Access installed. If your files have
more than that checked then YOU did something to make that happen. Often the
extra ones are not really needed and you can eliminate cross-PC problems by
simply unchecking them. As long as your project still compiles without errors
then you don't need the reference.

 

[Guest]

The databases compile fine and work fine on my machine however thats not so

 

[Rick Brandt]

The databases compile fine and work fine on my machine however thats
not so on other machines. Do you know where do references come from?
What I was thinking is that the reference should follow the db
shouldnt it?

Yes of course the "reference" follows the file. The problem is that the
actual resource *being referenced* might not exist on the other PC.

Which version of Access are you using and which references do you have
checked? The defaults (which are really the only ones you should ever have
checked on a file you want to share with others) are...

Access 97:
Visual Basic For Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library

Access 2000:
Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library (optional but often used)

Access 2002:
Visual Basic For Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library (optional but often used)

Access 2003:
Visual Basic For Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library

 

[Guest]

We have just upgraded to office 03. I did go through the databases and check
the ones you have noted below so hopefully this will work for them. Thank
you.

Do you know where do references come from?

 

[Rick Brandt]

We have just upgraded to office 03. I did go through the databases
and check the ones you have noted below so hopefully this will work
for them. Thank you.

Do you know where do references come from?

As I said before the entire list is based on all of the registered COM
libraries on your PC. Additional ones get "Checked" automatically when you
play around with the ActiveX controls on the form and report design toolbox
under the "More Controls" button.