ADO, DAO or OleDb?

[HKSHK]

Hi guys,

I'm currently struggling with my database connectivity for a
VB.NET/ACCESS database software. I currently use OleDB, but I find it
quite cumbersome compared to DAO.

Is there anything of importance (e.g. instabilities, crashes, etc.)
which would require me to use OleDb or ADO?

Thanks in advance for your help!

Best Regards,

HKSHK

 

[Cor Ligthert [MVP]]

HKSHK,

Only ADONET is managed code. ADONET has not much to do with ADO than that it
is probably planned as successor of that.

OleDb has nothing to do with those. It is a provider to connect your
database as there is ODBC, SQLClient and OracleDB in Net.

Therefore OleDb is probably what you are asking for and than in combination
with ADONET.

See here a sample to show something from an access database (you can even
forget the last part because this is a master-detail situation).

http://www.vb-tips.com/default.aspx?ID=a1a84750-08df-49b4-8657-7bc3068aca2c

I hope that this gives an idea,

Cor