sglee
asked on
Compile Error in query expression in ACCESS 2010
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.
Typically, this would be a sign of a Missing Reference. Can you post a screen shot of the current References on this machine ?
I am not seeing
Microsoft Office 14.0 Access Database Engine Object
reference ...
mx
Microsoft Office 14.0 Access Database Engine Object
reference ...
mx
ASKER
OK. I will add Microsoft Office 14.0 Access Database Engine Object to the reference once the user is gone for the day.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Since that is the only difference, let me un-install 64bit Office and install 32bit to see if that makes the difference.
ASKER
After installing 32bit Office 2010, the error has disappeared.
Thank you for your help.
Thank you for your help.
Excellent !