I have a rather large VB4 application that accesses an Access database
using the Jet Engine. I now want to change the application to also access
an SQL Server database.

If I read the documents etc. I have available it seems to suggest that I
should use the RDO object in combination with the ODBC API to do this.  

Is it best that I access the Access database in this manner also? ie. is it
faster ( alot or a little) than the Jet Engine for both types of database ?

Alternatively if I continue to use the Jet Engine, do I need to use the
ODBC API as well?

And, do I really need to use the ODBC API if I use the RDO object?

To change the application to using the RDO object will involve a LOT of
work but it is worth doing if it will speed up things considerably.

Hopefully there is someone out there that can help here!

Regards..........Deb Lethbridge