Sharing database creating error messages for missing or broken ref to mscomct2.ocx

[apartain]

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!

[MMcCarthy]

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!

You need to open the VBA editor on each machine and see if any of the libraries are marked as missing on the references list. It's possible these users don't have the libraries you used available on their lists.

Mary

[ADezii]

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\system32\stdole2.tlb
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\dao360.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\ADO\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\MICROS~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\system32\COMCT232.OCX
Version Number: 1.1
Kind of Reference: 0
Is the Reference Broken?: Intact

[apartain]

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\system32\stdole2.tlb
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\dao360.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\ADO\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\MICROS~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\system32\COMCT232.OCX
Version Number: 1.1
Kind of Reference: 0
Is the Reference Broken?: Intact

1) Being a VBA newbie, where do I put this in the VB Editor?

2) Where and when will it run? I am assuming upon opening the database?

3) If the references are not intact, how do I proceed?

4) Is this something that is recommended any time I create a shared database?

Thanks!

[ADezii]

1) Being a VBA newbie, where do I put this in the VB Editor?

2) Where and when will it run? I am assuming upon opening the database?

3) If the references are not intact, how do I proceed?

4) Is this something that is recommended any time I create a shared database?

Thanks!

__1. You can place it in a Standard Code Module as a Public Sub-Procedure:

Public Sub AnalyzeReferences()
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
End Sub

__2. It can be run anywhere in your Application at any time simply by calling it:

Call AnalyzeReferences

__3. From the Code Window ==> Tools ==> References. Find the missing Reference, it will be preceeded by MISSING:. Select the Reference ==> Browse ==> Navigate to the Folder indicated on the Full Path of Reference line on your Printout for the specific Reference ==> Open.
__4, It will not hurt to run this Procedure, but it is only recommended when you are experiencing potential Missing Reference(s) problem(s).