Database not found error. There is no open data connection.
I've been running this script successfully many times but now I get this error. I'm connecting to an Access database on my desktop. It's not open, I repaired and compacted it just in case. I moved it into a subfolder. Nothing has resolved the issue. Why would it all of a sudden give me this error after working many times? I didn't change the Access database in any way.
the first commented one worked then gave the error so I made another one below and it still gives the same error.
//OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Users\ZY0004\Desktop\OutageWork\Outage Work off.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;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];
//LOAD ID, // `MDR Date 0`, // many more fields
//FROM `Outage Dates`; //
2nd try:
OutageDates:OLEDBCONNECT32TO[Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Users\ZY0004\Desktop\OutageWork\Outage Work off.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;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]; SQL SELECT * FROM `Outage Dates`;
