I have an application in vb2010 Professional that reads and writes to Access and Excel. It works with Office 2010 32 bit but I have a client who creates huge spreadsheets and would like Office 64 bit.
I think in vb2010 I can target a 64 bit machine. How do I communicate with Access 2010?. My current code is:
con1.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = C:\VB\Test VB RWC.accdb "
StrSql2 = "SELECT * from materials order by materials.name"
db = New OleDb.OleDbDataAdapter(StrSql2, con1)
'txtName.Text = ds1.Tables("MDataSet").Rows(0).Item(1)
Me.DGV1.DataSource = ds1
I assume once I fill the dataset I manipulate it the same as office 2007.
I am an engineer programmer s
View Complete Post