Link to home
Start Free TrialLog in
Avatar of sglee
sglee

asked on

Compile Error in query expression in ACCESS 2010

User generated image
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.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

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

ASKER

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

User generated image
I am not seeing

Microsoft Office 14.0 Access Database Engine Object

reference ...

mx
Avatar of sglee

ASKER

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

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sglee

ASKER

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

ASKER

After installing 32bit Office 2010, the error has disappeared.
Thank you for your help.