ADO problem and DAO question

[lambela8]

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?

I think u should try RDO using ODBC
------
1st - u must create Data Source Name (DSN)-Any name
2nd - select the MsAccess path
3rd - U can ignore the desciption, it's up to U
-------
4th - run your VB Application
5th - Goto project|Reference and add Microsoft Remote Data Object
6th - Add Component - Microsoft remote data control
7th - you can specify all the property mainly at Custom

I you cannot get it please ask for sample (takes time a bit)


------------------
Khamal

[MartinLiss]

As to why your manual filling of a combo box seems slow, you'll need to post the code so people can possibly help you improve it.

------------------
Marty

[Clunietp]

Go here to see how to open a password protected database using ADO:
http://vbcode.webhostme.com/en/code.asp?id=86

Smalig: Could you fix this code? you need a CRLF after your 'set cn = new connection statement' -- Thanks

[Clunietp]

Oh yes, DAO is faster than ADO for Jet Databases. All future improvements / upgrades will be to ADO. M$ is phasing out RDO and DAO, so start porting your code to ADO if possible.