none
using old access databases

    Question

  • I started using Visual Basic in 2002. Back then I used Access Databases. I later purchased a new computer in 2009. I also purchased Visual Studio 2008. In order to use the Access Databases I needed to use Microsoft.JET.OLEDB.4.0. I now have a new PC that uses a 64-bit version of Microsoft.

    This causes me a problem when using Microsoft.JET.OLEDB.4.0. I tried to go to properties and change platform target from any CPU to x86. I am having problems doing this. Could you please help me out?

    Tuesday, February 28, 2017 4:25 PM

All replies

  • I wish it was, but Microsoft in fact even advises with MS-Office 2016 to use the 86  version. 

    6c6f49b8d261https://support.office.com/en-us/article/Choose-between-the-64-bit-or-32-bit-version-of-Office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261

    To translate the marketing language. You can take the 64 bit version only if everything you do is bound to a 64 bit PC and there are no parts which don't work with 64 bit(That is for instance everything that is not direct needed for Microsoft office itself in versions later then 2010). 


    Success
    Cor



    Tuesday, February 28, 2017 5:31 PM
  • Hi friend,

    Please share us which error you have encountered, which could be helpful for me to troubleshot your issue.

    Sincerely,

    Oscar


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, March 01, 2017 5:57 AM
    Moderator
  • Hi,

    Windows 64-bit can run 32-bit or 64-bit apps.

    Microsoft Office 2013/2016 can be 32-bit or 64-bit. You can install 2013 and 2016 at the same time, but must be both 32-bit or both 64-bit.

    Visual Studio is a 32-bit app that needs the x86 Access components to connect to an Access database for its features that connect to a database. For this reason, you may want to install Office 32-bit on your development computer.

    You can use Visual Studio to create:

    - A 32-bit only (x86 platform target) app that uses the x86 Access components

    - A 64-bit only (x64 platform target) app that uses the x64 Access components

    - A dual (32-bit or 64-bit depending on the bitness of Windows) (Any CPU platform target) app that uses the x86 Access components on Windows 32-bit and the x64 Access components on Windows 64-bit.

    Microsoft Access 2013 Runtime (x86 or x64)

    https://www.microsoft.com/en-us/download/details.aspx?id=39358

    Microsoft Access 2016 Runtime (x86 or x64)

    https://www.microsoft.com/en-us/download/details.aspx?id=50040

    Unless you need the app 64-bit, stick to 32-bit with x86 target platform and use the x86 Access components.


    My portal and blog about VSX: http://www.visualstudioextensibility.com<br/> Twitter: https://twitter.com/VSExtensibility<br/> MZ-Tools productivity extension for Visual Studio: https://www.mztools.com

    Thursday, March 02, 2017 1:20 PM