I have several fairly complicated, multi-user Access applications that we have been running in Access 2010 for about 4 years. We are now facing the prospect of migrating to Office 2016 - including Access, of course. This is a corporate setting, and we actually had a couple cases of the 2016 version getting pushed out to user computers with no advance warning.

We are not using Access in the "conventional" way - with bound forms and controls and such. We are really using it mainly as a platform for form & query design, and to run large amounts of VBA code. This brings the Object Libraries under references into play.

We were using a "Find File" code block for navigating to upload files (usually Excel or .txt) and this blew up when using Access 2016, but an EE expert provided us with an alternative using fDialog code that works in both environments. Our challenge is that when we load an Application using 2016, it modifies the Reference inventory to the 16.0 set - specifically the Access database engine Object library, the Outlook 16.0 Object Library (we generate emails from within some of our applications) and the Office 16.0 Object Library. Then - if we try to load the application on a 2010 machine - we get a missing reference error because the 2010 boxes use the 14.0 Libraries. Worse, there does not seem to be a 1:1 relationship between the 14.0 and 16.0 libraries. (I can't find a 14.0 library that corresponds to the "Microsoft Office 16.0 Object Library.")

…

Dear EE,

How do i determine which MS SQL 2008 R2 Native Client 32 bit or 64 bit is installed on my Windows 2008 R2 64 Bit Standard Edition ?

Thanks

sometimes, when answering questions on EE, i think i hit a combination of keys, and the pc starts reading aloud everything on the page.
i looked how to stop that, but could not find it - except closing the window, but this is frustrating if you were in the middle of a rather long post

surely somebody knwos how?

I closed an unclosed question - I know I said I wasn't ever going to do this again but it looked obvious.  I selected the questioner's own reply as the best solution.  Why does he get 500 points to answer his own question?

How to delete Saved Searches and stop the damn hourly notices?
These damn things are annoying as hell and suddenly, without any involvement from me, have been turned on and I cannot stop them! I'm assuming it was a wonderful idea from someone at E-E.

- I've changed notifications to none by deselecting all of the hourly notification settings
- I attempted to find the place in E-E to delete the search, just so I stop getting notified, and cannot find that.

Please assist with how to stop these hourly notices and with deleting the search.