Sample Header Ad - 728x90

Access 2010-2016 Compatibility Error

3 votes
3 answers
10104 views
I was just updated to Access 2016, while my users are still at Access 2010. I opened our database in MS Access 2016 once, didn't make any changes, and closed it out, and now all the users are having errors for **ANY** basic VBA code, including: StrConv (Me.FormField, vbProperCase) DoCmd.GoToRecord DoCmd.RunCommand acCmdSaveRecord etc. However, it works fine on my end. Totally broken for all my users on Access 2010. Is there any way to fix this? I am thinking, even if I go back to Access 2010, if these are errors for code that would normally work fine in either version, how to I resolve these errors? Tried a compact and repair, no effect. Here's an example: In Access 2010, when the AfterUpdate() event is triggered on a textbox that has the StrConv (Me.FormField, vbProperCase) function, it brings up the VBA debugger. The error is: **Compile error: cannot find project or library.** Previously, the exact same function worked fine in access 2010, and there have been no changes to this code. It works fine in a backup copy from about 15 days ago.
Asked by pblo (31 rep)
Jun 24, 2016, 04:00 PM
Last activity: Dec 11, 2018, 10:00 PM