I am trying to schedule an update query to run at night on a Timberline (Pervasive SQL)database. The problem is you have to supply it with a user ID & password to access data. How can I supply this in VBA? I have tried the ADODB open & it accepts user ID & PW (I know because when i use wrong PW...
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.