code library

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know if there is a way to determine in access what library the vb
code is using. We have some code that use to work when we all had office xp,
but we moved to office 2003 and I am assuming that because of the 11 library
the code doesn't work.

I also know you can't have both 10 and 11 libraries installed.

Please let me know if there is a way to tell, and if the code should work ?
 
Here is a small Sub that will tell you what references you have establishted.
If you are on Access 2003 and Office 2003, your libraries will be version
11. This sub will print the library name and location for all your references
in the immediate window.

Sub CheckReferences()
Dim objRef As Reference
Debug.Print "you have " & Application.References.Count & " References"
For Each objRef In Application.References
Debug.Print objRef.Name & " " & objRef.FullPath
Next
End Sub
 
Klatuu,

Is there a way for stuff written in code 10 library to work in or with the
11 library ?
 
What version of Office are you running?
What version of Access?
It can be done, but can cause problems. You will have to have the version
10 libraries available, but there could be conflicts with version 11.
In short, I would not advise it. What is the reason you see necessary to do
this?
 
We have access 2002 and office 2003.. Well most of us do.. We have a few
users that have office XP and access 2002 and need access to the DB.
 
Okay, that can be a mess. I know 2002 uses version 10 and 2003 uses version
11. I don't know about XP. The trick is that those libraries that are used
just for Access should be version 11. If you are using automation, say to
communicate with Excel objects, then those should be version 10 for the 2002
users. You will have to find out what version XP is.

Here is a link that may help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;283115
 
Office XP = suite of products containing Access 2002, Excel 2002, etc.
(technically there is no such thing as Office 2002 or Access XP but the
terms XP and 2002 have become interchangable in practice)
 
Are you suggesting that Microsoft would stoop to a confusing marketing ploy
to sell product? :)

Okay, then, all you need to be concerned with as far a versions go is to use
the version 11 libraries for Access libraries, and version 10 for libraries
you use for automation.
 
Because we bought the products indepent of eachother I classified them like I
did.. sorry for the confusion..

So let me get thsi striaght.. if in the vb code that might use other
application like excel and word we tell it to use the correct library
11(office 2003) but tell access to use library 10(access 2002) that should
work and can be done...

Any samples or use that KB article
 
Back
Top