how to connect Access Database with VB.net

[Guest]

pls tell me would it be wise to start learning database programming with
VB.net and msaccess 2003?
abdullah

 

[Larry Linson]

pls tell me would it be wise to start learning database programming with
VB.net and msaccess 2003?

Access and VB.NET do not interact, but the Jet Database Engine works with
VB.NET, using ADO.NET. Access is the user interface and development tool,
which, by default, installs and uses the Jet Database Engine -- an "Access
database" usually refers to a Jet database.

It would not necessarily be "unwise" to start learning database programming
with VB.NET and a Jet 4.0 database. Whether it would be particularly
helpful will depend on what you know, already, and what your goal is. If
you want to create applications with VB.NET and Microsoft SQL Server, you
should be aware that there are differences in the dialects of SQL. And
those differences will be even more apparent in SQL Server 2005 than in
earlier versions.

Larry Linson
Microsoft Access MVP

 

[aaron.kempf]

Learning MDB would be stupid.

Anyone that uses MDB is stupid. It doesn't scale; it isn't reliable.

Spit on anyone that uses MDB for anything.

Yes; of course it is easier and more practical to learn 1 version of
SQL than two.
These MDB jackasses don't know how to use SQL Server

-Aaron