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"