simply data connection query... has me stumped!

[Aussie Rules]

Hi,

I am use to working against SQL Server databases, but now am trying to
connect to a basic Access 2007 accdb I have my my local dev machine.

I know I have not kept up with the latest technologies, but there seems to
be a few to many ways to connect, OLEDB, ADO, ADO.net, RDO etc...

What I want to know is what is the best 'method' in VB2008 to connected to
an Access 2007 accdb.

I want to be able to use vb.net code to connect, so any samples would be
great!

Thanks

 

[Cor Ligthert[MVP]]

Aussie,

http://en.wikipedia.org/wiki/OLEDB

http://en.wikipedia.org/wiki/ActiveX_Data_Objects

http://en.wikipedia.org/wiki/ADO.NET_Entity_Framework

http://en.wikipedia.org/wiki/Remote_Data_Objects

As you probably have seen more often than I have the opinion that there is
no "Best" in Net, that is only were it is proven as by instance France in
the case of Rugby.

My choose would be ADONET and OLEDB as it is about Access if I have to do it
quick. If I want to try something than I would take LINQ with OLEDB.

Cor