Robert Putney
asked on
Very strange Access 2016 problem
We have a database that gets daily use by ~100 employees and has worked flawlessly for years. 6 months ago I deployed 13 identical new computers with Windows 10 Pro and Office 365 (effectively Office 2016). Most of the rest of the office runs Windows 7, with a mix of Office 2010 and Office 2016. Everything worked great.
In the past 2 weeks, 2 of the 13 new builds have encountered the following error:
"The expression On Click you entered as the event property setting produced the following error: The OpenForm action was cancelled.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluation the function, event, or macro."
The .mde program opens normally, and prompts me to login. Upon trying to login, the error message is generated. When it occurred on the first machine, I'm not sure how I eventually resolved it. I tried many things repeatedly, and suddenly it worked.
The second machine failed today, and I could not resolve it. I even formatted and reinstalled a clean copy of Windows 10, installed Office 365, and tried again. No change.
There is currently no antivirus running. This machine is on a domain, and the mdb file is on a network drive. Any thoughts on what is going on here?
In the past 2 weeks, 2 of the 13 new builds have encountered the following error:
"The expression On Click you entered as the event property setting produced the following error: The OpenForm action was cancelled.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluation the function, event, or macro."
The .mde program opens normally, and prompts me to login. Upon trying to login, the error message is generated. When it occurred on the first machine, I'm not sure how I eventually resolved it. I tried many things repeatedly, and suddenly it worked.
The second machine failed today, and I could not resolve it. I even formatted and reinstalled a clean copy of Windows 10, installed Office 365, and tried again. No change.
There is currently no antivirus running. This machine is on a domain, and the mdb file is on a network drive. Any thoughts on what is going on here?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER