Create a new module and write this function inside
Public Function RefreshCache() as boolean
On Error GoTo Error
DBEngine.Idle dbRefreshCache
RefreshCache = True
Exit Function
Error:
RefreshCache = False
End Function
Then you can use this function in your VBA...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.