Category: DataBase

I’ve read through a great bunch of articles where users reported issues with accessing Access DB files using the Microsoft.Jet.OLEDB.4.0 provider.  This is predominantly reported on latest Windows platforms essentially x64 versions those most probably running the latest version of Access 2007 or beyond.   As on Access 2007, Microsoft confirmed that Microsoft.Jet.OLEDB.4.0 is a Deprecated Data Access Method.  For more details refer to MSFT article Deprecated Data Access Methods.

Summary: Learn how to develop either native (C, C++, Java, VBA) or managed (C#, Visual Basic.NET) data access code with Microsoft Office Access 2007 or Microsoft Access 2010. Learn about the Access architecture, the ACE engine and data providers, 32-bit and 64-bit platforms, and what things to consider when you choose an optimal data access technology for your new or legacy database project. Applies to: Microsoft Access 2010 | Microsoft Office Access 2007 Published: September 2010 Provided by: Aleksandar Jakšić, Microsoft Corporation Contents Overview Architecture of the Microsoft Access Engine Overview of Data Access Technologies Performance Data Using 32-bit and […]