I placed a database on the server and all of the other users are receiving the error message:
Your Microsoft Access database or project contains a missing or broken reference to the file 'mscomct2.ocx' version 2.0
This is a virtual network and we are all running our own copies of Access.
I did use several ActiveX controls. Can anyone tell me what the other users need to do? Is there a download they can perform?
Thank you!
Here is a code snippet that you can utilize to Reference References (light humor). At least it will give you some status information pertaining to the References on each machine:
- Dim MyRef As Reference
-
-
For Each MyRef In Application.References
-
Debug.Print "Reference Name: " & MyRef.Name
-
Debug.Print "Is the Reference Built-In: " & IIf(MyRef.BuiltIn = True, "Yes", "No")
-
Debug.Print "Full Path of reference: " & MyRef.FullPath
-
Debug.Print "Version Number: " & MyRef.Major & "." & MyRef.Minor
-
Debug.Print "Kind of Reference: " & MyRef.Kind
-
Debug.Print "Is the Reference Broken?: " & IIf(MyRef.IsBroken = True, "Broken", "Intact")
-
Debug.Print vbCrLf
-
Next MyRef
Typical Output: Reference Name: VBA
Is the Reference Built-In: Yes
Full Path of reference: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6 \VBE6.DLL
Version Number: 4.0
Kind of Reference: 0
Is the Reference Broken?: Intact
Reference Name: Access
Is the Reference Built-In: Yes
Full Path of reference: C:\program files\microsoft office\OFFICE11 \msacc.olb
Version Number: 9.0
Kind of Reference: 0
Is the Reference Broken?: Intact
Reference Name: stdole
Is the Reference Built-In: No
Full Path of reference: C:\WINDOWS\syst em32\stdole2.tl b
Version Number: 2.0
Kind of Reference: 0
Is the Reference Broken?: Intact
Reference Name: DAO
Is the Reference Built-In: No
Full Path of reference: C:\Program Files\Common Files\Microsoft Shared\DAO\dao3 60.dll
Version Number: 5.0
Kind of Reference: 0
Is the Reference Broken?: Intact
Reference Name: ADODB
Is the Reference Built-In: No
Full Path of reference: C:\Program Files\Common Files\System\AD O\msado21.tlb
Version Number: 2.1
Kind of Reference: 0
Is the Reference Broken?: Intact
Reference Name: MSACAL
Is the Reference Built-In: No
Full Path of reference: C:\PROGRA~1\MIC ROS~4\OFFICE11\ MSCAL.OCX
Version Number: 7.0
Kind of Reference: 0
Is the Reference Broken?: Intact
Reference Name: Office
Is the Reference Built-In: No
Full Path of reference: C:\Program Files\Common Files\Microsoft Shared\office11 \mso.dll
Version Number: 2.3
Kind of Reference: 0
Is the Reference Broken?: Intact
Reference Name: ComCtl2
Is the Reference Built-In: No
Full Path of reference: C:\WINDOWS\syst em32\COMCT232.O CX
Version Number: 1.1
Kind of Reference: 0
Is the Reference Broken?: Intact