VB.NET中访问2016的连接字符串 [英] Connection string for access 2016 in VB.NET

问题描述

您好，

我在vb.net中使用此连接字符串来访问Access 2013

Hello,
I used this connection string in vb.net for Access 2013

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=xx/xx.accdb; Jet OLEDB:Database Password= xx;

然后在使用Access 2016之后它不起作用

我应该使用哪个连接字符串？

谢谢，



我尝试过：



几件但不起作用

then after used Access 2016 it doesn't work
which connection string should I use?
Thanks,

What I have tried:

several things but doesn't work

推荐答案

JET引擎仅适用于32位应用程序，从不适用于64位。

您可能已经安装了64位版本的Access 2016，并且根本不能与JET一起使用。



说真的，我强烈推荐你废弃JET并转移到支持32位和64位引擎和代码的ACE。

The JET engine was only available for 32 bit apps, never for 64 bit.
The chances are that you have installed the 64 bit version of Access 2016, and that can't be used with JET at all.

Seriously, I'd strongly recommend you scrap JET and move to ACE which supports both 32 and 64 bit engines and code.

这篇关于VB.NET中访问2016的连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！