I have an old VB6 application using a couple of .MDB database files.

The databases were created with Access 2007, and I believe it should be a simple matter to upgrade them from .MDB to .ACCDB file format.

I would then like to use ADO instead of DAO in the VB6 program.

Will I encounter any unpleasant surprises?

Is there any DAO functionality that is missing from ADO?

Will ADO enable me to overcome the DAO limitation of 14-character database passwords?