Searching online, I found one critical change between office 365 and older versions: The use of PtrSafe. I found some suggestions online about error 2950, which were related to Access Trust/Security, so I copied all the related entries in the registry from to I also looked through the code modules and found several red lines in many of them, all related to external function declarations. Since I opened the database from within the Access editor, the error came with the suggestion to recompile the code, which triggered me: How hard could it really be to fix this code to actually work on office 365? VBA Error 2950: Can not compile the following statement:=ng_Autoexec() I just realized (I know, I'm a bit slow) that opening Access 365, and then opening the database from there, could trigger the error: Details on the fix are posted in this comment:
It does not appear to be related to reboots, either.Īny pointers to a solution would be highly appreciated, as at the moment I spend far more time on waiting for Access Runtime 2010 to repair-install than I do adding the data I have to add.Įdit: Forgot to note that others in my company do not have this problem.Įdit2: Worked around the problem, by fixing the database to run on Office 365. Sometimes within hours, other times there are 14 days or more in between.
(The final reboot isn't necessary for the database to be opened.) To "fix" it, I have to repair-install Access Runtime 2010, only then does the old icon appear in the "Open with." dialog. dll files, restoring a default hive in the registry, complete reinstall of access, etc. However, often the Access Runtime 2010 icon disappears, and I'm not able to open the database with any of the (2) versions of msaccess.exe I can locate on my computer - they both lead to Access 365 getting loaded. (When searching, I notice there are 2 versions of msaccess.exe installed) If I attempt to open the database, it will by default open in Access 365, but using "Open with." I'm able to select "the old Access icon", which represents Access Runtime 2010. This is dictated by my work, and nothing I can change.Īs part of Office 365, I also have Access 365 installed, but I never use it. I (unfortunately!) have to open a database with GUI that requires Access Runtime 2010 to add a few new entries a couple of times every month.
0 kommentar(er)
