simple question

[ashwini123]

what are the different methods
of connecting an vb application
to an msaccess database which
is sitting in the same computer?
Please give me sample programs or
detailed help.

thanks in advance.

[Jimbob]

There's probably too many to go into, but the most common one would be to access the DB using ADO, but even then there are so may ways of implementing that...

The simplest way is probably to use a datacontrol, but there are otherways such as dealing with connections and recordsets yourself, using a Data Environment or a Data Aware Class module. my preferred methods are the latter two.

There's an excellent tutorial on this very site, at http://www.vb-world.net/articles/dbtutorial6/

This begins with the basic stuff and will give you a good idea of how it all works

hope this is of some help...

there's also another way of connecting to an access database. you add a data environment, rt click to get the connection's properties, and select your OLE DB provider. it's quite easy to go from there.