You can also try this:
Dim myCommand as new OledbCommand
Dim myConnection as new OledbConnection([Connection String])
myCommand.Connection = myConnection
myCommand.CommandText = [SQL string]
There are a few tricks to connecting to an Access Database. You need to know the connection string, you can locate the connection string at www.Connectionstrings.com
. Older versions of Access use the Jet engine, which will need to be stated in the connection string, as nadhan_f showed in the con.Open line, while Access 07 uses a different engine.
The command text needs to show the sql string that you are going to execute (ie "Select * from sto_Employees")
The command type will tell the application what to run, some examples are:
ExecuteQuery - used for select queries
ExecuteNonQuery - used for insert, update and delete queries
ExecuteReader - used to run a data reader
What command type you use will depend on what you are trying to do.
Hope this helps.
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.
US (German-born) physicist (1879 - 1955)