troubleshooting Question

Access 2013 ACCDE file not running on specific computers

Avatar of Mel Brooks
Mel Brooks asked on
Microsoft OfficeMicrosoft AccessMicrosoft 365VBA
14 Comments1 Solution111 ViewsLast Modified:
We have an Access front end application (sql server backend) which is developed in Office 2010 and compiled using Access 2010.  When we distribute the application, it has run with no issues on systems running Access 2010 - 2019 in retail versions,  volume licensed editions,  Office 365 subscriptions , on OSs from Windows 7 through Server 2016.
Now we have Lenova workstation that when running simple VBA function code its giving an error.

"3075 function is not available in expresssions in query expression  ((tblEmphistoryStartDate) < Date() - 1)"

If I compile the Access application on this machine, then I do not get this error when running the compiled accde version.
The 2013 build on this computer 15.0.5111.1001.  is the same as a server on the same network and it runs the accde compiled in 2010 without error.

I'm lost as to what to look for to correct this on the workstation.  I have run Office Repair from Control Panel and that did not correct it.  

Any suggestions are welcome.
ASKER CERTIFIED SOLUTION
Mel BrooksCITO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros