using ado.net with access

i am having problems in using ado.net with my access db. I have an example using a mysql server but i cant find any information regarding ado.net with access. can anybody help with a tutorial or sample code on just how to setup connection and execute sql statement on the db

thanks

Sample Form and database attached. Make sure you set the "strDataBasePath" string at the top to the path of your database ie. "C:\Products.mdb"

thanks for the reply, one question. how do i actually run the code to see it in operation??? the run button is disabled. do i need to call it from somewhere else???

thanks again

i am getting the following error
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

this refers to the following line of code
OleDbCommand1.Connection.Open()


any ideas?

Yes, Make sure you set the "strDataBasePath" string at the top to the path of your database ie. "C:\Products.mdb"

Hi Jason,

Could you tell me why you use

" Me.OleDbConnection1 = New system.Data.OleDb.OleDbConnection()"?

I thought the following would suffice;

Me.OleDbConnection1 = New OleDb.OleDbConnection()

Many thanks