J
Jeff Gaines
I am using the trial version of Office 2007 (I am awaiting delivery of my
own version) having taken a large leap from Office 97.
I accessed the 97 version of Access using ADODB but, if it makes sense, I
want to try and learn how to use ADO.NET with the new version. I write
Windows Forms apps in C# for my own enjoyment/education. (which may mean I
am asking in the wrong group)
I started up a new project and fell at the first hurdle because VS2005
doesn't recognise the new Access format (.accdb). So question 1 is is
there an add on/upgrade available or do I have to save my shiny new Access
databases in the 2003 format?
I don't like using the Data Connector etc. controls, I have always found
it easier and quicker to roll my own in code.
I am used to using ADODB.Connection and ADODB.Recordset and connection
strings like:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";...
So question 2 is is it possible to carry on using that technique with
ADO.NET or should I learn to use the built in controls?
I would appreciate any thoughts and pointers to sample projects/how to's,
this may be the biggest leap I have made since the days of VB6
Many thanks.
own version) having taken a large leap from Office 97.
I accessed the 97 version of Access using ADODB but, if it makes sense, I
want to try and learn how to use ADO.NET with the new version. I write
Windows Forms apps in C# for my own enjoyment/education. (which may mean I
am asking in the wrong group)
I started up a new project and fell at the first hurdle because VS2005
doesn't recognise the new Access format (.accdb). So question 1 is is
there an add on/upgrade available or do I have to save my shiny new Access
databases in the 2003 format?
I don't like using the Data Connector etc. controls, I have always found
it easier and quicker to roll my own in code.
I am used to using ADODB.Connection and ADODB.Recordset and connection
strings like:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";...
So question 2 is is it possible to carry on using that technique with
ADO.NET or should I learn to use the built in controls?
I would appreciate any thoughts and pointers to sample projects/how to's,
this may be the biggest leap I have made since the days of VB6
Many thanks.