From: HarvestWind@comcast.net   
      
   Hi:   
      
   Trying to use ADO in VB 6.0 so that I can access a Access 2000 database that   
   has security assigned with users and user passwords.  Tried DAO, but kept   
   getting "not a valid password" when I tried to set the recordset.  So   
   switched to ADO.  It works on my machine (which is running Windows 2000 XL   
   Professional).. it also works on three other machines running Windows 2000.   
   However, on one specific machine, I get an error saying that automation is   
   not supported...I have no idea what the heck is going on.  I even tried to   
   add the ADO reference DLL to my project and distributed it to the other   
   machines...it still works on all the machines but that one specific one.   
      
   Does anyone know why ADO would not work on just one machine when working on   
   all the others?  Or, how in the world can I access an Access 2000 database   
   that is password protected using DAO?  I've tried to use the format provided   
   in Help for the connection:   
       secSQL = (My SQL Statement)   
      
       Set SecDb = OpenDatabase(SecSQL,dbDriverNoPrompt, True,   
   DATABASE=Security; UID=Software;PWD=Software1;DSN=Utility")   
           (SecSQL is my sql statement   
            my DATABASE name is "Security"   
           my UserID is set up as "Software"   
           my Password is "Software1"   
           The table is "Utility")   
      
   I have tried this format with numerous substitutions and all I get is   
   "Invalid Password" statements.  So, does anyone know how to solve my ADO   
   problem...or how to access an Access 2000 Database that has user's and   
   groups assigned?   
      
   Any assistance would be appreciated.   
      
   Thanks   
   JP   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)