[02/03] MS Access interface: Your Opinion

I know this isn't the Database forum, but this form provides better answers and exposure. What is best (pros and cons) to use when interfacing with an MS Access database: ADO or OleDb?

Quote:

---

Originally Posted by circuits2

I am developing an application that uses an Access database. What is the best (pros and cons) to use as the interface: ADO or OleDb?

---

ADO and OLE DB are the same thing. ADO is a more user friendly API for OLE DB.

Depends on what your using for your front end? VB 6 or .NET etc.

.NET has optimized providers for Accecss - OleDbConnection, OleDbDataAdapter, etc.

Please dont cross forum post. ;)

I will merge the other thread with this one. ;)


Done. :)


Edit: Since this is now deemed as VB.NET you should be using ADO.NET vs ADO or anything else.