Isaac
Lifelong Learner
- Local time
- Yesterday, 20:04
- Joined
- Mar 14, 2017
- Messages
- 8,777
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.)
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.)