MDAC Roadmap and .mdb files

I know this isn't SQL server related but this seemed to be the only appropriate forum.

I would like to work with Access databases (.mdb files) via (non-managed) C++. At the moment I'm using the ODBC provider for OleDB. However I see from the MDAC "Data Access Technologies Road Map" that this provider is deprecated. The OleDB/ADO alternatives seem to be focussing on SQL server only; I just want a 'local', non-networked desktop system. What technology should I use that isn't deprecated?

Yours,

Peter

If you are using C++ and either OLE DB or ODBC then you might want to consider SQL Server 2005 Express Edition (http://msdn.microsoft.com/sql/express/).

I'd also recommend looking at C++/CLI (there's an Express edition for Visual Studio 2005 also - http://msdn.microsoft.com/vstudio/express/visualc/default.aspx). It's now very straightforward to mix native and .Net code so you can get the best of both worlds - reuse your code and add new features/UI with .Net at your own pace http://msdn.microsoft.com/msdnmag/issues/04/05/VisualC2005/ and http://msdn.microsoft.com/msdnmag/issues/05/01/COptimizations/

|||

Thanks for your answer. That has given me confidence that I can stick with my current system for the time being, but shift to SQL Server in the future, as required. My database needs are pretty simple and I think I could do it without actually changing any code apart from the connection string.

Pete

MCDBA Roadmap

Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> Hey Guys,
> Does any 1 have the roadmap to MCDBA? If you have the document, please
> send
> me a link where I can download or please email the document to
> seelanr@.hotmail.com
> Thanks
>
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
> "Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
> news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||What are you talking about if not the MCDBA requirements? The roadmap
is simply do the 3 core exams (SQL design, SQL admin & one of the Win
Server exams) and 1 of the electives (mostly dev/design exams). Or do
you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ?
etc.? If so then this may (or may not) be helpful:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:

>Thanks Rick
>But that web page only has the requirements and NOT the ROADMAP.
>"Rick Sawtell" <Quickening@.msn.com> wrote in message
>news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
>
>
>|||Hey Guys,
Thanks for the replies but What I am looking for is the steps/the order in w
hich I take the courses/ exam.
-Seelan
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:OJgWJBoNGHA.3936@.
TK2MSFTNGP10.phx.gbl...
What are you talking about if not the MCDBA requirements? The roadmap is simply do the
3 core exams (SQL design, SQL admin & one of the Win Server exams) and 1 of the electi
ves (mostly dev/design exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCD
BA (SQL 2005) -> ? etc.? If so then this may (or may not) be helpful: http://ww
w.microsoft.com/le.../mcitp/dbadmin/
mike hodgson
http://sqlnerd.blogspot.com
Seelan Raja wrote:
Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please
send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA|||There are no steps. Order is unimportant. You can take them in any
order you feel like. Each exam is independent in it's own right. Many
people like to do the ones they are most comfortably with first (ie. the
ones they think they are most likely to pass) to give them a confidence
boost for the harder ones but it's all just personal preference.
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:
[vbcol=seagreen]
> Hey Guys,
> Thanks for the replies but What I am looking for is the steps/the
> order in which I take the courses/ exam.
> -Seelan
> "Mike Hodgson" <e1minst3r@.gmail.com <mailto:e1minst3r@.gmail.com>>
> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
> What are you talking about if not the MCDBA requirements? The
> roadmap is simply do the 3 core exams (SQL design, SQL admin & one
> of the Win Server exams) and 1 of the electives (mostly dev/design
> exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA
> (SQL 2005) -> ? etc.? If so then this may (or may not) be
> helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Seelan Raja wrote:
>

MCDBA Roadmap

Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> Hey Guys,
> Does any 1 have the roadmap to MCDBA? If you have the document, please
> send
> me a link where I can download or please email the document to
> seelanr@.hotmail.com
> Thanks
>
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
> "Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
> news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||What are you talking about if not the MCDBA requirements? The roadmap
is simply do the 3 core exams (SQL design, SQL admin & one of the Win
Server exams) and 1 of the electives (mostly dev/design exams). Or do
you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ?
etc.? If so then this may (or may not) be helpful:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:

>Thanks Rick
>But that web page only has the requirements and NOT the ROADMAP.
>"Rick Sawtell" <Quickening@.msn.com> wrote in message
>news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
>
>
>
|||Hey Guys,
Thanks for the replies but What I am looking for is the steps/the order in which I take the courses/ exam.
-Seelan
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
What are you talking about if not the MCDBA requirements? The roadmap is simply do the 3 core exams (SQL design, SQL admin & one of the Win Server exams) and 1 of the electives (mostly dev/design exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ? etc.? If so then this may (or may not) be helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
mike hodgson
http://sqlnerd.blogspot.com
Seelan Raja wrote:
Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please
send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||There are no steps. Order is unimportant. You can take them in any
order you feel like. Each exam is independent in it's own right. Many
people like to do the ones they are most comfortably with first (ie. the
ones they think they are most likely to pass) to give them a confidence
boost for the harder ones but it's all just personal preference.
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:
[vbcol=seagreen]
> Hey Guys,
> Thanks for the replies but What I am looking for is the steps/the
> order in which I take the courses/ exam.
> -Seelan
> "Mike Hodgson" <e1minst3r@.gmail.com <mailto:e1minst3r@.gmail.com>>
> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
> What are you talking about if not the MCDBA requirements? The
> roadmap is simply do the 3 core exams (SQL design, SQL admin & one
> of the Win Server exams) and 1 of the electives (mostly dev/design
> exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA
> (SQL 2005) -> ? etc.? If so then this may (or may not) be
> helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Seelan Raja wrote:
sql