Switchboard error (for only one user of 10)

[Therat]

I set up a switchboard that opens up a few data entry forms. It sits on our network and around ten users assess it throughout week. There is one user that can't open up the switchboard anymore (he used to be able). Now he as an error that opens up the visual basic debugger. The error it highlights: set con = application.current project.connection. Any thoughts why it is only occurring on his computer? He has the exact same computer specs and we all use Access 2002.

Thanks in advance,
TheRAT

 

[ghudson]

Check for a missing reference.

 

[Therat]

Still don't understand..

Missing reference, from where?..... why is he the only user that experiences this error? Help me understand...

Thanks

 

[Rich]

Search the archives here, this problem appears on a regular basis

 

[Therat]

Missing reference

I searched the site and found what I thought was the answer, but.....

I looked in the VB debugger in tools>>references and I looked for "missing" references. I didn't see any. Will it be obvious if there are missing refs? I compared the computer that works correctly with the bad computer and they both have the same references check and the priority order is the same. Any other ideas?

Thanks in advance!
TheRAT

 

[ghudson]

You looked in the right spot to verify a reference problem. I am out of ideas for that error if everybody is using the same version of Access.

 

[Rich]

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Therat]

And the answer is.....

Not a missing reference! But thanks for playing.

This behavior was a result of a damaged or a corrupted Microsoft Data Access Components (MDAC) stack.

http://support.microsoft.com/default.aspx?scid=kb;en-us;306132&Product=acc