Future of different Windows data access technologies
Posted: (EET/GMT+2)
Sometimes, people ask me which data access technologies are still supported today, and which are about to be phased out. On MSDN, there's an article titled "Data Access Technologies Road Map" from June 2007 that lists these technologies.
Shortly put, many older, native-code level features have either been declared deprecated (meaning you should consider changing them to something newer) or obsolete (meaning that support for these technologies has ended).
Of course, Microsoft is pushing developers towards SQL Server, which is actually good thing in that thus applications will become more robust. The other side of the coin is that many simpler technologies, like Access via Jet is deprecated. This means that if you are still using Access as your (simple) database, you might wish to consider SQL Server Compact Edition. Interestingly enough, Microsoft's own Access 2007 still uses Access databases of course. However, I'm not sure which data access technology it uses internally so this MDAC/OLE DB related MSDN article might not apply.