Error in using Microsoft Access 2013 in LabVIEW

[GrayJoker]

My operate system is Win7(x64), and MS Office is version 2013(x64). My LabVIEW is Version 2015(x32), and I have installed AccessDatabaseEngine_X64.exe. Then I  run the demo "Connect to ACCDB Database.vi", but following error happened.

    

How can I handle this?

[RavensFan]

I don't know if this would be it, but one thing I see in you images is that the access string calls out Access2007.accdb but you say you are connecting to Access 2013.

[GrayJoker]

Access 2007. accdb is the name of database file.

[RavensFan]

I never heard of an .accdb extension.  It always used to be .mdb.  Did microsoft change that up in a recent version of Access?  Access2007.accdb is a weirdly generic name for an access file.  Especially for one you are building in Access 2013.

Okay, you have the path going in.  But you have double backslashes between the path and the database name.  Are you sure that is correct?

Another possibility, I see Chinese characters in your error message talkinga about the connection path, but nothing in that connection string is indicating chinese.Why would the dialog box convert the connection string to Chinese characters?  What do they say?

[aputman]

You may need to specify the driver in your connection string as well.  From Microsoft website: Link

If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”

If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:

File Type (extension)                                             Extended Properties
---------------------------------------------------------------------------------------------
Excel 97-2003 Workbook (.xls)                                  "Excel 8.0"
Excel 2007-2010 Workbook (.xlsx)                             "Excel 12.0 Xml"
Excel 2007-2010 Macro-enabled workbook (.xlsm)      "Excel 12.0 Macro"
Excel 2007-2010 Non-XML binary workbook (.xlsb)      "Excel 12.0"

If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file” 

[henry_2020]

Hello Gray,

Is this problem solved?

Thanks!