Compile Error in query expression in ACCESS 2010

sglee
sglee used Ask the Experts™
on
Access Error
Hi,
 I have an user who gets this error when running a specific report based on a query.
 When I run the same report from other ACCESS2010 and ACCESS2003 installations, there is no error.
 I repaired the office 2010 on that user's PC to no avail.
Earlier today there was an another error so I removed a broken link in references. After removing a broken reference, now I see this error.

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Typically, this would be a sign of a Missing Reference.  Can you post a screen shot of the current References on this machine ?

Author

Commented:
Here it is, but it is the same on other 2010 ACCESS PCs.

References
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
I am not seeing

Microsoft Office 14.0 Access Database Engine Object

reference ...

mx
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
OK. I will add Microsoft Office 14.0 Access Database Engine Object to the reference once the user is gone for the day.

Author

Commented:
After adding "Microsoft Office 14.0 Access Database Engine Object", I am still getting the same error. The one thing to add is this user has 64bit version of Office 2010 because he is the only person who has 64bit version of Windows 7 Pro.
Database Architect / Application Developer
Top Expert 2007
Commented:
"64bit version of Office 2010 "
Well, that is a entirely new ballgame ... not sure what is up.

mx

Author

Commented:
Since that is the only difference, let me un-install 64bit Office and install 32bit to see if that makes the difference.

Author

Commented:
After installing 32bit Office 2010, the error has disappeared.
Thank you for your help.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Excellent !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial