Use VBA to set Current Database options > Caching (1 Viewer)

Isaac

Lifelong Learner
Local time
Today, 09:42
Joined
Mar 14, 2017
Messages
8,738
Does anyone know how to use VBA to set the Current Database options for "Caching Web Service and Sharepoint Tables" ?

I'm using automation to link to a Sharepoint list. I always have to go into the Current Options and set "Never Cache" manually, but I'd rather do it by VBA. (the Never Cache option is needed to overcome a bunch of errors that arise otherwise once you try to Open, or Update, the Sharepoint linked table.)
 

Users who are viewing this thread

Top Bottom