using ado.net with access

[id123]

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

[jwmoore2001]

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"

[id123]

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

[id123]

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?

[jwmoore2001]

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

[taxes]

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