I'm still using the vb6 development environment but I want to step up the database and ado versions to the latest and greatest. I'm currently using the following to connect to an access 2000 mdb:
Set conn = New Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPOSPath & ";Jet OLEDB:Engine Type=4;Jet OLEDB:Database Password=test"
also I haven't found ado 6.0 for download yet, any ideas?