Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the Below connection to Access DB
OLEDB CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source= MY_Database;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False];
Using QV 12, Win Server 2016
When I trigger the reload its asking for the Service account password. So If I try to run it from QMC it fails. BUt if Run the same job on the server QV desktop it runs after entering the password. How can I disable the password prompt.
Resolved, needed to add the URL for the access database to the Trusted sites in IE
Resolved, needed to add the URL for the access database to the Trusted sites in IE