OLE vs ODBC Connection for Access Database

[Auguy]

Is there a "Best Method" of connecting to an Access database? I have connected using OLE, but just wondered if ODBC is a better solution? I have seen both methods in sample code in this and other forums. Are there any advantages or disadvantages to using either one? If it makes any difference I only have to read from the Access database.

Auguy
Northwest Ohio

 

[jebenson]

OleDB is a newer technology, and most data providers support it. With ODBC you will have to write code to set up a DSN on the end users' computers; this is not required with OleDB. Basically, the only time I would ever use ODBC is in the remote chance the data provider does not have OleDB support.


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[Auguy]

Thanks, that's what I was looking for.

Auguy
Northwest Ohio