Can you not open a password protected Acess 2000 database with ADO? I choose Jet 4.0 as the provider, but whenever I test the connection it says workgroup file is missing or the database is locked exclusively. I put the password in but to no avail. I end up using oledb, but it takes forever to produce results with ADO. Why do I keep having trouble out of ADO. It seems as though DAO is faster and simpler, but everywhere I read says ADO is the best thing to ever happen. What is the deal?

Also, how come using the data control (DAO) fills a combo box fast but if you fill it in code it takes a while (Using a loop). Is there a faster way around this?