Hi, I am a newbie and have tried connecting to a Access database on my desktop. I have used the below with no luck, I get the following error: Line 24: (File "C:\Documents and Settings etc. $adoRs.Open ($query, $adoCon) $adoRs.Open ($query, $adoCon)^ERROR Error: The requested acction with this object has failed. $dbname = "C:\Documents and Settings\DOHERTYW\Desktop\NHS Status.mdb" $tblname = "TBL_LowerCase" $query = "SELECT * FROM " & $tblname & " WHERE DistrictNumber = 1"
