csciarro
asked on
MS Run-Time Error when accessing Access database
I have an access database and when I try to access it using either 32BIT or 64BIT run-time I receive the following error message. The database was created in MS Access 2013 and is being accessed using the 2013 run-time program. I am able to access it on the full version of MS Access. Any ideas on how to resolve this issue?
See attached document and error information below.
"This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs."
Access-Runtime-Error.docx
See attached document and error information below.
"This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs."
Access-Runtime-Error.docx
ASKER
Ok. When I try to access it on a 32 or 65BIT machine with the correct runtime bit version I receive the same error message. any thoughts on how I can correct this without using the full version of access?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you create the .accde/.accdr with 32-bit Access you MUST use 32-bit Access or Access runtime to run it. Same for 64-bit. You have to run the app with the same bit-wise version you used to create it.
The .accdb is more flexible. As long as you are not using any Windows API's, your Access .accdb files will work in either version. If you have API code, and you must support multiple bit-wise versions, you MUST use conditional compilation.
Bottom line - If you don't have to install the 64-bit version of Office don't do it. Even Microsoft recommends sticking with the 32-bit version. There is nothing to gain by using the 64-bit version except the ability to create humongous spreadsheets and INMNSHO, that isn't a benefit. If you use addins, you loose all your addins unless the vendor has also created a 64-bit version.