Sorry Shane, I misunderstood you the first time.
Here are the correct results:
"Starting Test.
Date: 21/08/2014 Time: 1:10:22 PM
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using DAO...
--Successful
Opening Table...
--Successful
Closing connection to the database.
--Successful
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using ADO...
ERROR!: 91 - Object variable or With block variable not set
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Done, Test Complete.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''